Code fails after upgrading to Office 2007
 

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