Run Time Error 13

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I Imported a file into an access database. The file contains only four
fields. The first one is an autonumber (Long) called ID. The next three are
255 position fields.

I get a run-time 13 error when I try to open it in VBA.

Dim dbDAO As DAO.Database
Dim db as Database

set db=CurrentDB
set dbDAO = CurrentDB

Set rstI = db.OpenRecordset("SELECT * FROM DACSSC")

I tried both DAO and Standard as you can see, I get the same error on both.

Any help would be appreciated

Len
 
Declare a DAO recordset object:

Dim db As DAO.Database
Dim rstl As DAO.Recordset
Set db=CurrentDB
Set rstl = db.OpenRecordset(...
 
Back
Top