Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 32164

Jun 3rd, 2004

VB6 and MS Access 2002

Expand Post »

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

Similar Threads

Win98 v. Access 2002 in Visual Basic 4 / 5 / 6
Upgrading to Microsoft Access 2002 in MS Access and FileMaker Pro

JB1

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2004

Permalink

Jun 9th, 2004

Re: VB6 and MS Access 2002

problem with code, VB 6 could be opened using Access as well as oracle.

Vinoth

Reputation Points: 13

Solved Threads: 2

Junior Poster

Offline

125 posts
since Jun 2004

Permalink

Jul 13th, 2004

Re: VB6 and MS Access 2002

Quote 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.

mnemtsas

Reputation Points: 16

Solved Threads: 1

Posting Whiz in Training

Offline

200 posts
since Jul 2004

Permalink

Jul 21st, 2004

Re: VB6 and MS Access 2002

Dear,
your solution is quite simple as i have had been through the same problem untill i came to know that Vb6.0 doesnot support MS Access 2002 and its databases.so all that you need to do is convert your MS access files into the previous version and this how you do is just open MS Access file then click on Tools->Database Utilities->Convert Database->To Access 97 Format.
try this it should work for you.

Quote 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

siraj

Reputation Points: 13

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2004

Permalink

Jan 5th, 2005

Re: VB6 and MS Access 2002

????? ADO supports MS Access 2002 please engage brain before posting please

mnemtsas

Reputation Points: 16

Solved Threads: 1

Posting Whiz in Training

Offline

200 posts
since Jul 2004

Permalink

Feb 25th, 2005

Re: VB6 and MS Access 2002

Hey, You can use access 2k
add the Microsoft ADO Data Control to your form, right click and then click properties.
you then want the last one and then build. make sure your database connects, then close that box
in the ADODC properties you should have a "Record Source Tab"
change that so you have the right table then in the "DataSource" property of your txt/label change that to adodc1, then change your datafield to the one you want to use.
try that

uniquestar

Reputation Points: 49

Solved Threads: 11

Posting Whiz in Training

Offline

239 posts
since Feb 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Addnew problem

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Command Button Validation

DaniWeb Message

Cancel Changes

User Name
Password