Jet database engine cannot find the input table?

[steve728]

The following code, which works with other tables just fine:

Dim rs As Recordset
Set rs = New ADODB.Recordset
rs.Open "SELECT * from glsingle", adoConnection, adOpenStatic, adLockReadOnly

results in th following error message:
"The Microsoft Jet database engine cannot find the input table or query 'GLSingle'. Make sure that exist and that its name is spelled correctly."

It exists bigger than heck! What's going on! I deleted it and reimported it from Foxpro. It still doesn't work. Any clues? It opens just fine when I double click on it.
Help!

Steve

 

[steve728]

The following shed some light on my problem. It seems as though ANY file that I import now will cause the same error!
Why doesn't Access find the table when it's obviously there?

Please help me. This is really putting a crimp in my day!

Thanks,

Steve

 

[steve728]

I found the trouble cyber buddies! It was a datapath that had been changed without my knowing. Thanks anyway to all of you. What a comfort it is to know that you folks are always there!

Onward hoe!

Steve