Re: Logging MSACCESS

From: <irwin_goldstein_at_my-deja.com>
Date: Mon, 03 Apr 2000 18:30:05 GMT
Message-ID: <8canuo$if4$1@nnrp1.deja.com>

Use of an ODBC driver with a server based request broker component such as OpenLink will allow you to do this and more. You can down load a demo at http://www.openlinksw.com. You'll want to get the "multi-tier" version of their drivers.

Among the many advantages of this type of product has over "native" ODBC drivers is that you can define custom SQL to be executed upon each connection. This can vary by user, client name/IP address, application name, etc.

HTH, Irwin Goldstein
Objective Software Systems, Inc.
http://www.objectsoft.com

In article <38e7ee5d.646757968_at_news-server>, dyork_at_houston.rr.com wrote:
> I have a large corporate database which allows users to connect to the
> data via a vb app or through acess if they so chose. The problem is
> that I have set the app to log what is used and sessions etc.
> However, I want to log when someone logs on using Microsoft Access
> through a linked access table and store the userid, program, and time.
>
> Can this be done?
>
> Thanks
> dyork_at_coair.com
>

--
Irwin Goldstein
Objective Software Systems, Inc.
http://www.objectsoft.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 03 2000 - 13:30:05 CDT