1,105,232 Community Members

can we connect VB 6 wtih databases in Ms Office Access 2003?

Member Avatar
an_nurif83
Newbie Poster
3 posts since May 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

ai..
i have try alot of times connecting the database in Ms Office Access 2003 with VB 6. bUT there is error when i try to connect between "record source" in vb with data that i save.Can anyone help me and give me some advise,references or way to solve this prob.Plz..I reallly appreciate.Thanx

Member Avatar
Comatose
Taboo Programmer
2,536 posts since Dec 2004
Reputation Points: 290 [?]
Q&As Helped to Solve: 227 [?]
Skill Endorsements: 34 [?]
Team Colleague
 
0
 

Here is a fantastic tutorial covering the use of ADO with Visual Basic.... This should help quite a bit:
http://www.timesheetsmts.com/adotutorial.htm

Member Avatar
hatem
Newbie Poster
4 posts since Jun 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

hello there,
as far as i know vb6 can only manage access 97 file formats.
so if you wanna get access to your database you should convert it into access 97 file format.
to do that go to Tools >> Database Utilities >> Convert Database >> To Access 97 file Format .after that you will not be able to modify your database.
i am not sure if you have already done that , but i hope this helps.
hatem..

Member Avatar
techniner
Posting Pro
521 posts since May 2005
Reputation Points: 2 [?]
Q&As Helped to Solve: 20 [?]
Skill Endorsements: 0 [?]
 
0
 

Ok First off:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en


Second..
Add these librarys in your project
Microsoft Activex Data Objects Recordset 2.7 Library
Microsoft Activex Data Objects 2.7

And finally..

http://support.microsoft.com/default.aspx?scid=kb;en-us;238401

Member Avatar
thomas49th
Newbie Poster
2 posts since Jun 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

You HAVE to convert the database file to a 97 format. Vb6 was written when office 97 was out so they only desgined it to be compatible with 97 format. When you convert you canoot edit the file. You'll have to edit it in 2003 then convert it again. Best to use the visual data tool in vb or get a copy of office 97.

Member Avatar
techniner
Posting Pro
521 posts since May 2005
Reputation Points: 2 [?]
Q&As Helped to Solve: 20 [?]
Skill Endorsements: 0 [?]
 
0
 

Why not just do this in sql?

Member Avatar
jwshepherd
Junior Poster
123 posts since Jun 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
0
 

Service pack 6 would fix this problem and add the libraries techniner said. You do not need to change the format to 97. The access 2003 default database is created as an access 2000 database anyway.

Member Avatar
techniner
Posting Pro
521 posts since May 2005
Reputation Points: 2 [?]
Q&As Helped to Solve: 20 [?]
Skill Endorsements: 0 [?]
 
0
 

I rest my case.... :cheesy:

Member Avatar
Faik
Newbie Poster
4 posts since Oct 2006
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

I hope this is not too late.
VB6 (and even VB5) can work with Access 2000 and 2003 databases using either ADO or DAO object. For ADO, just specify Jet 4.0 as a prvider:

Provider = Microsoft.Jet.OLEDB.4.0;

With DAO it is something different. VB5 and VB6 use MS Jet 3.5 and DAO 3.51, and for Access 2003 and 2000 you need DAO 3.6 and MS Jet 4.0.
So, if you do not have MS Jet 4.0 installed on your computer, you should download it form http://support.microsoft.com/?kbid=829558

Then in your VB project open menu Project->References
Then turn off the Microsoft DAO 3.51 Object Library (if checked) and
Check (turn on) the Microsoft DAO 3.6 Object Library.

And that's all. Now your project will work with Access 2000 and 2003 databases using DAO object.

I hope this helps.

BR,
Faik

Question Answered as of 7 Years Ago by techniner, hatem, thomas49th and 3 others
Member Avatar
Comatose
Taboo Programmer
2,536 posts since Dec 2004
Reputation Points: 290 [?]
Q&As Helped to Solve: 227 [?]
Skill Endorsements: 34 [?]
Team Colleague
 
0
 

Yup. VB6 has also the ability to use the "createobject" function for late binding of objects. Which basically means, that any program (including office 2k / 2003) that has a public base class IS ACCESSIBLE from vb6.....

Member Avatar
vnanthan
Newbie Poster
1 post since Jan 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

ai..
i have try a lot of times connecting the database in Ms Office Access 2003 with VB 6. but there is error when i try to connect between "record source" in vb with data that i save.Can anyone help me and give me some advise,references or way to solve this prob.Plz..I reallly appreciate.Thanks

Member Avatar
debasisdas
Posting Genius
6,542 posts since Feb 2007
Reputation Points: 580 [?]
Q&As Helped to Solve: 476 [?]
Skill Endorsements: 25 [?]
Featured
 
0
 

How you are connecting to database ?

through code or by setting properties only ?

please mention the error code and error message for further assistance.

Member Avatar
vb5prgrmr
Posting Virtuoso
1,670 posts since Mar 2009
Reputation Points: 143 [?]
Q&As Helped to Solve: 299 [?]
Skill Endorsements: 3 [?]
 
1
 
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article