OK I managed to get the Profiler to write audit logon and audit logoff events to a table, but this seems to record multiple rows when I am using my...

Simon, that's just what I need

Many thanks

Stefan

Klaas-Jan, thanks for your reply.

My app is set up so that it will first use NT Authentication but where this not available has to use SQL Authentication.

Not a problem...

Hi I got the code to work in Access 97 by changing it to the following:

Public Sub VersionX()

Dim cnn As ADODB.Connection

Dim strVersionInfo As String

' Open connection.

Set cnn = New ADODB.Connection

cnn.Open...

Thanks, your answer helps me with part of the question and that it how to identify the ODBC version.

Access 97 VBA does not like the syntax of the code...

Simon, Access 97 does not recognise the command 'sqldmo'. Is this a program I have to download?

Antares686, I don't get when I assign myq.connect = strconnect?

The error occurs when the...