OpenDatabase Problem in VB

[Roger Denison]

I have an Access98 db that I converted to Access2000.
I'll call the databases DB98 and DB2000, respectively.

Now in my VB code I want to open a database so I use
something like:

Set dbMain = OpenDatabase(DB98).

When I do this I get something for dbMain. However if I
use:

Set dbMain = OpenDatabase(DB2000),

I get, in essence, 'dbMain = Nothing'.

I am modifying some existing VB code that was written to
work with the older 98 db. I made all the necessary name
changes so that the OpenDatabase method tries to open the
2000 db but I get nothing. I don't get any errors,
just 'nothing'.

What would cause this?

Roger.

 

[Dan Artuso]

Hi,
Have you applied the latest service pack for VB?

 

[TC]

Probably not the answer, but: you should always qualify dbengine object
methods with the dbengine keyword - explicitly. Thus,
DBENGINE.opendatabase(). Otherwise, all sorts of strange DAO licencing &
other errors can occur in certain cases.

HTH,
TC