•
•
•
•
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 370,612 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,064 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.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 24002 | Replies: 5
 |
•
•
Join Date: Jun 2004
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
VB6 and MS Access 2002 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
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
•
•
Join Date: Jun 2004
Posts: 125
Reputation:
Rep Power: 5
Solved Threads: 1
Junior Poster
problem with code, VB 6 could be opened using Access as well as oracle.
Webdevelopers and Programmers Forums | Tips for Freelance PHP Coders | Best Search Engine | Get Connecting JSP with MySQL |
•
•
Join Date: Jul 2004
Location: Adelaide, Australia
Posts: 191
Reputation:
Rep Power: 5
Solved Threads: 1
Junior Poster
•
•
•
•
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
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
•
•
Join Date: Jul 2004
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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.
•
•
•
•
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
•
•
Join Date: Jul 2004
Location: Adelaide, Australia
Posts: 191
Reputation:
Rep Power: 5
Solved Threads: 1
Junior Poster
????? ADO supports MS Access 2002 please engage brain before posting please
Mark Nemtsas
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
•
•
Join Date: Feb 2005
Location: London, UK
Posts: 231
Reputation:
Rep Power: 4
Solved Threads: 11
Daniweb Sponsor
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
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Linear Mode
Similar Threads
- Access 2002 (Visual Basic 4 / 5 / 6)
- Upgrading to Microsoft Access 2002 (MS Access and FileMaker Pro)
- New key word not recoginized in VB6 connecting to Access (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Addnew problem
- Next Thread: Command Button Validation
