Can't get ODBC Connection

[Trudye]

I am running Access 2000 on Windows 2000. I am not running on a network, and I have a DSL line.

I created a ODBC connection the same way I did under 97. Now I am getting the msg shown below.

I looked the msg up in MS knowledge Base and it referred to a TCP/IP connection, Netware5 Servers. I sure what MS was saying did not apply to me. Does anyone have any idea what it is I must do to get an ODBC connection?

Microsoft JET Database Engine error '80004005'
'C:\UsersDB\NTS_Data_97.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/UserSignInForm.asp, line 19


Also here is the code I am usint for the connection:
Set Cnn1 = Server.CreateObject("ADODB.Connection&quot
Cnn1.connectiontimeout=30
Cnn1.commandtimeout=40
myDSN="PROVIDER=Microsoft.Jet.OLEDB.4.0;"
myDSN=myDSN & "data source=C:\Users\NTS_Data.mdb;"


Thank you
Trudye

 

[DeZiner]

This must not be a valid path: C:\Users\NTS_Data.mdb

Check using windows explorer if NTS_Data.mdb really exists on the c drive uner Users DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[Trudye]

I ams sure the path is correct. I copied and pasted the path in the code to be absolutely sure. I then copied and pasted the database name in the code.

I wish it was that simple. Of course I am no stranger to stupid mistakes I have made my share. Unfortunately this is not one of those times.

Thanks for the input
Trudye