TheCandyman
Technical User
I'm having some coding issues, i have worked on this for days, and know i'm overlooking something small. I connect to a DB and it seems to connect to it just fine. If i change the path it give an error it can't find the file, so it does map the correct path. I take the SQL line it outputs and run that directly in the DB, it pulls correctly. So it has to be with the connection, and i have double checked the file, it is there.
This is the Error
Normally this just means i spelled a name wrong and it can't find that name in the DB, but here is the table in the Access DB.
Anyone have any ideas????
Code:
Set AzDA = CreateObject("ADODB.Connection")
strAzDA = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath ("/reg/Regdb/WEBDB.MDB")
AzDA.open strAzDA
Set AzDArs = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT ADANum FROM Meminfo WHERE ADANum='"& EnteredAzDA &"';"
response.write SQL
AzDArs.open SQL,Conn,0,2,1
IF not AzDArs.eof THEN
.....
This is the Error
Code:
SELECT ADANum FROM Meminfo WHERE ADANum='11111111';
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'Meminfo'. Make sure it exists and that its name is spelled correctly.
/reg/stage3.asp, line 101
Normally this just means i spelled a name wrong and it can't find that name in the DB, but here is the table in the Access DB.
Anyone have any ideas????