Access Help Needed!

M

Michael Erlewine

I have been importing FoxPro tables into Access for sometime and then using
them with Visual Basic 6.0. No real problems.

All of a sudden, the Access tables won't open.

When it reaches the line:

Set ds = db.OpenRecordset (SQL$)

I get a mewssage "The Microsoft Jet database engine cannot find the input
table or query ....

The Access database is spelled correctly and in the right directory.

The funny thing is that Access databases made earlier in the day open
fine... and the VB code is identical, except for the different file names.

Any idea MUCH appreciated.

Thanks,

Michael Erlewine
 
Top