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

[an_nurif83]

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

[Comatose]

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

[hatem]

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

[techniner]

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

[thomas49th]

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.

[techniner]

Why not just do this in sql?

[jwshepherd]

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.

[techniner]

I rest my case.... :cheesy:

[Faik]

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

[Comatose]

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

[vnanthan]

[QUOTE=an_nurif83;128704]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

[debasisdas]

How you are connecting to database ?

through code or by setting properties only ?

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

[vb5prgrmr]

see http://www.connectionstrings.com

Good Luck