SQL Database Code Error. Help Quick please.

[jesus4u]

With this code

'--Enter emails in DB

	Dim Dconn, sSQL, sSQL2, sSQL3, cmDC, SQL, Recordset
			
	Set Dconn = Server.CreateObject("ADODB.Connection")
		Dconn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & _
		               databasepath & ";"
		               
	Set cmdDC = Server.CreateObject("ADODB.Command")
		cmdDC.ActiveConnection = Dconn
		
	SQL = "SELECT * FROM Emails"
			
	SQL = "Select * FROM Sender.Email WHERE " & "Sender.Email ='" & SenderEmail & "'" 
			
	cmdDC.CommandText = SQL
	Set RecordSet = Server.CreateObject("ADODB.Recordset")

+++++++++RecordSet.Open cmdDC, , 3, 3

I get this error:


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\WINNT\system32\Sender.mdb'.
/bbb.org/emailer/EmailIn.asp, line 111
---------------------------------------
line 111 marked with +++++++++

I have a DB named Emails.mdb that has the path

Const databasepath c:/inetpub/wwwroot/bbb.org/emailer/emails.mdb

Why is it looking for 'C:\WINNT\system32\Sender.mdb'?

Help!

[Cander]

Dont know. what is the variable databasepath set to?

[jesus4u]

is this what you mean?

Const databasepath = "c:/inetpub/wwwroot/bbb.org/emailer/emails.mdb"