working with Access2000 databases

[Heikki Salomäki]

How can I work with Access2000 databases? I'm using Vb 6.0 Sp3. For example
this doesn't work:

Set db = OpenDatabase("mydbs.mdb")

It works with Access97 but not with Access2000 databases. Should I use ADO
or wath?

[Arthur Wood]

Heikki,

You will be well advised to use ADO for Access2000.

You might also make sure that you are referencing DAO 3.6 for the Access
2000 database.(Access 97 used DAO 3.51)

Arthur Wood

"Heikki Salomäki" <hsalomak@cc.hut.fi> wrote:
>How can I work with Access2000 databases? I'm using Vb 6.0 Sp3. For example
>this doesn't work:
>
>Set db = OpenDatabase("mydbs.mdb")
>
>It works with Access97 but not with Access2000 databases. Should I use ADO
>or wath?
>
>

[Larry Rebich]

Heikki,

Some months ago I wrote a tip of the month that I call 'What I Learned About
DAO 3.6 and Jet 4.0'. Link to http://www.buygold.net/tips.html then look for
the July 1999 tip of the month. A sample program is provided that creates a
Jet 4 [Access 2000] database. The required DLLs can also be downloaded from
the site.

Cheers,
Larry Rebich

More tips link to:
http://www.buygold.net/tips.html

Please:
No personal e-mail questions :-)


"Heikki Salomäki" <hsalomak@cc.hut.fi> wrote in message
news:3a2f5ed5$1@news.devx.com...
> How can I work with Access2000 databases? I'm using Vb 6.0 Sp3. For
example
> this doesn't work:
>
> Set db = OpenDatabase("mydbs.mdb")
>
> It works with Access97 but not with Access2000 databases. Should I use ADO
> or wath?
>
>

[Paul Clement]

On Thu, 7 Dec 2000 11:58:13 +0200, "Heikki Salomäki" <hsalomak@cc.hut.fi> wrote:

¤ How can I work with Access2000 databases? I'm using Vb 6.0 Sp3. For example
¤ this doesn't work:
¤
¤ Set db = OpenDatabase("mydbs.mdb")
¤
¤ It works with Access97 but not with Access2000 databases. Should I use ADO
¤ or wath?
¤

See the following:

PRB: Getting Unrecognized Database Format Error Message When Upgrading to Access 2000
http://support.microsoft.com/support.../Q238/4/01.ASP


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)