Re: VB6 and MS Access 2002

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 402,027 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,482 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

VB6 and MS Access 2002

•

Join Date: Jul 2004

Location: Adelaide, Australia

Posts: 191

Reputation: mnemtsas is an unknown quantity at this point

Rep Power: 5

Solved Threads: 1

mnemtsas

Offline

Junior Poster

Re: VB6 and MS Access 2002

Jul 13th, 2004

•

Originally Posted by JB1

Dear all,

I have a question around the issue of using VB6 to access MS Access databases. Can VB6 be used to open access 2002, retrieve data from and input data into a table?

The following code keeps on giving me the message of "Unrecognised database format" error code 3343.

Dim DBSource As Database
Set DBSource = OpenDatabase("h:\training\names.mdb")

Is the problem with this code, or is it because VB6 can't open an access 2002 database?

Thanks in advance for your help.
JB1

Try taking a look at my ADO Tutorial. It explains how to interact with Access DB's of any persuasion from VB.

Mark Nemtsas

Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books