SQL.log

B

Brenda Hutton

Client reports that in Access 2000, a file called SQL.log has been created
and is updated every time the database is opened. She does not know how it
originated or how to stop this. The file at one time topped 800 megs. How
do we turn this off? It happens with all her databases. TIA!
 
D

Dirk Goldgar

Brenda Hutton said:
Client reports that in Access 2000, a file called SQL.log has been
created and is updated every time the database is opened. She does
not know how it originated or how to stop this. The file at one time
topped 800 megs. How do we turn this off? It happens with all her
databases. TIA!
Click to expand...

Are these database using tables that are linked to an ODBC data source,
such as SQL Server? Maybe this article decribes what's going on and how
to stop it:

http://support.microsoft.com/default.aspx?scid=kb;en-us;268591
PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk
Space
 
Top