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

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

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

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

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

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

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

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

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.

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

Why not just do this in sql?

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

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.

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

I rest my case.... :cheesy:

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

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

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

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

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

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

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

How you are connecting to database ?

through code or by setting properties only ?

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

Re: can we connect VB 6 wtih databases in Ms Office Access 2003? 80 80
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.