Access 2000 with VB 6.0

[Jesse L Hansley Jr]

Can someone tell if vb 6.0 is compatible with MS Access 2000. I put an
Access 2000 database in the properties box. When go to record source I get
an error message. This doesn't happen when I use Access97 database. I get
a list of tables.

Thanks

[Tony Toews]

"Jesse L Hansley Jr" <je***********@verizon.net> wrote:

Can someone tell if vb 6.0 is compatible with MS Access 2000. I put an
Access 2000 database in the properties box. When go to record source I get
an error message. This doesn't happen when I use Access97 database. I get
a list of tables.

Search on that exact error message. You need the Jet 4.0 drivers in your references
and not the Jet 3.5 drivers.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Larry Linson]

"Jesse L Hansley Jr" wrote

Can someone tell if vb 6.0 is compatible with MS Access 2000.

This is addressed in Knowledge Base article 238401, but was updated in one
of the Service Packs to VB6. Access 97 (which uses Jet 3.51) was current
when VB6 was originally released; so you have to set appropriate references
to use the later Jet 4.0.

Strictly speaking, you are using a Jet database and the Jet database engine,
not "Access", although even Microsoft uses that shortcut description.

If you haven't applied all the Service Packs, you may have other undetected
problems -- so I'd suggest a visit to the Microsoft web site to determine
and obtain the Service Packs.

Larry Linson
Microsoft Access MVP

[Jesse Hansley]

Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!