
February 16th, 2004, 03:42 PM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Logging .mdb access in SQL Server
I have a SQL Server 2000 database that is accessed from multiple Microsoft Access databases via linked tables. I am trying to create a record in a table in the SQL database with specific information about the databases that are accessing the SQL database. The main fields I need are:
Username (I can get this in a trace)
Location of the .mdb file (have not been able to get this data)
Name of the .mdb database (have not been able to get this data)
Name of remote computer where the .mdb resides (I can get this in a trace)
I have tried a trace in SQL using the Profiler and an ODBC trace as well. The SQL trace does not give me the location or name of the DB that is accessing the SQL Server db- which is the most important of all of the data needed. The ODBC Trace is really not feasible because of overhead as well as you have to create the trace on the DSN or ODBC connection (as far as I know).
If there is a third party application that would do this, that would be great as well. ANYTHING will help!
Much thanks- your NEW user- DallasDeveloper
|