D
djenkins
I'm getting "Can't find project or module" and the word dbUseJet is
highlighted when attempting to run code in a spreadsheet that worked fine
with Office 2003.
Here is the code
Dim wrkJet As DAO.Workspace
Dim dbsMktStats As DAO.Database
Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
The code, when it worked, then went on to open a database and run some
queries.
I have not upgraded the DB to access 2007, but since the failure is on the
CreatedWorkspace command, I didn't think it was important (at least, not yet)
In Tools...References, I used to have "Microsoft DAO 3.6 Object Library"
checked, but someone suggested I uncheck this and check "Microsoft Access
12.0 Access database engine Object Lilbrary", so I tried that, still no good.
I also added (again, in "references") "Microsoft Access 12.0 Object
Library", but I get the same error every time.
Any suggestions would be appreciated.
David Jenkins
highlighted when attempting to run code in a spreadsheet that worked fine
with Office 2003.
Here is the code
Dim wrkJet As DAO.Workspace
Dim dbsMktStats As DAO.Database
Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
The code, when it worked, then went on to open a database and run some
queries.
I have not upgraded the DB to access 2007, but since the failure is on the
CreatedWorkspace command, I didn't think it was important (at least, not yet)
In Tools...References, I used to have "Microsoft DAO 3.6 Object Library"
checked, but someone suggested I uncheck this and check "Microsoft Access
12.0 Access database engine Object Lilbrary", so I tried that, still no good.
I also added (again, in "references") "Microsoft Access 12.0 Object
Library", but I get the same error every time.
Any suggestions would be appreciated.
David Jenkins