 |  |  |  |  |  |  |  |
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
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 |
•
•
•
•
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
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
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
????? 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
Posts: 238
Reputation: 
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
|
Similar Threads
- Win98 v. Access 2002 (Visual Basic 4 / 5 / 6)
- Upgrading to Microsoft Access 2002 (MS Access and FileMaker Pro)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Addnew problem
- Next Thread: Command Button Validation
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
