VB5.0 and Access 2000

  • Thread starter Thread starter HarvestWind
  • Start date Start date
H

HarvestWind

Hi.

Hi have Visual Basic 5.0 and have not used it in years. But it does not
connect to Access 2000 Databases using the included controls. I believe
that there is a "whitepaper" somewhere that tells how to connect to Access
2000...But don't know where it is.

We have extensive tables in Access 2000 and don't want to recreate them all
in an "earlier" version of Access tables...can anyone tell me where the
white paper is...or how to connect to my existing Access 2000 tables?

Thanks in advance for any assistance you can give me.

JP
 
Since VB5 predated Access 2000 by a fair bit, the controls aren't
compatible. The same problem occurred with VB6, but there they released
updated versions of the controls in one of the service packs.

You can still use VB5 with Access 2000, though: I'm just not sure whether
you can use the bound controls.

See whether there's anything in any of the following:

PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or
2002:
http://support.microsoft.com/?id=238401
FIX: The Data Form Wizard May Not Open an Access 2000 Database:
http://support.microsoft.com/?id=242010
HOWTO: Modify the Visual Data Manager (VISDATA) to Work with Access 2000
Databases:
http://support.microsoft.com/?id=252438
FIX: Unrecognized Database Format Error with Data Control or Data Form
Wizard:
http://support.microsoft.com/?id=257780
 
As I understand it, your "front end" is in VB5.0, and it reads data from an
Access database.
So you're not really concerned with Access controls at all, you just want to
read the Access data.
If Access 2000 is not installed on the machine where you're running the VB
program, try upgrading to MDAC 2.6. You can download this from the
Microsoft site; it may be all you need.

HTH
 
Actually, MDAC 2.6 doesn't include any Jet drivers: the last version to
contain them was MDAC 2.5 (and it only included the DAO 3.6 drivers anyhow)
 
Thanks, Douglas.

I went to the articles you suggested. One showed me how to "fix" the
Visdata program that came with VB5.0 and it can now read and display the
info from my Access 2000 databases.

The controls, however, cannot be bound to the tables/recordsets, etc in my
databases. I have to write the code to open the recordset and then assign
them to varous controls as needed. So, it is all the programming I was
hoping to avoid...:0>)....

Thanks so much for your assistance.

JP
 
Back
Top