PC Review


Reply
Thread Tools Rate Thread

Code fails after upgrading to Office 2007

 
 
djenkins
Guest
Posts: n/a
 
      23rd Jun 2008
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: WU Office 2007 sp1 FAILS with Code 57E / Vista Ultimate 32-bit Robert Aldwinckle Windows Vista Performance 0 11th Feb 2008 06:46 AM
Upgrading Outlook 2000 to 2007 Without Upgrading Office =?Utf-8?B?Q2hyaXN0b3BoZXIgQmVhcmQ=?= Microsoft Outlook Installation 1 1st Nov 2007 07:19 PM
Major problems with Outlook 2007 upgrading Office 2003 to Office 2007 Cris Microsoft Outlook 7 29th Aug 2007 12:54 AM
Major problems with Outlook 2007 upgrading Office 2003 to Office 2007. Cris Microsoft Outlook Installation 4 27th Aug 2007 09:04 PM
Major problems with Outlook 2007 upgrading Office 2003 to Office 2007 Cris Microsoft Outlook Discussion 1 26th Aug 2007 10:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:01 PM.