Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft JET Database Engine error '80040e37'

Status
Not open for further replies.

TheCandyman

Technical User
Sep 9, 2002
761
US
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.

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????
 
K, i tried these permissions

Everyone
Interactive
Network sErvices
User
Admin
IUSR_
Network
System

They all have read, some have write. But i still get the same issue. I think your write on permissions, but i just don't know what else to try????
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top