Open acess from excel (Office2003)

[alpder]

I have been using Office97 but have just upgraded to 2003 and converted my Access databases. I used to be able to open Access databases from Excel using:

Dim DB As Database
Set DB = OpenDatabase("P:\Factory\Rejects.mdb")

This no longer works (Runtime Error 3343. Unrecognisable data format)

Does anyone have any idea why this is happening?

 

[SkipVought]

Hi,

Have you set a reference to either ADO or DAO Object Library?

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[alpder]

No I have not referenced ADO or DAO Object library.

Which one should I use and can you point me to some information on the 2 systems?

Many thanks

alpder

 

[SkipVought]

Go to Tools/References and see what library is checked but no longer has a valid reference.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]