Access 2003 and VB

[nkechifesie]

I was unable to create foreign keys using Visdata and I have decided to create the database straight from Access but I would like to know if access 2003 would work with Vb6.

[Killer42]

I was unable to create foreign keys using Visdata and I have decided to create the database straight from Access but I would like to know if access 2003 would work with Vb6.

Yes, it will. I don't remember exactly what is required to get the two talking, but I use VB6 with Access 2000 at home, and 2003 at work. (For compatibility, I create all my databases in Access 2000 format.)

[padhuwork]

Yes, it will. I don't remember exactly what is required to get the two talking, but I use VB6 with Access 2000 at home, and 2003 at work. (For compatibility, I create all my databases in Access 2000 format.)

In Access 2003, set your default file format to Access 2000, that is whenever you create a file you it gets created in 2000 format, as mentioned by "Killer", Vb is compatible with Access 2000 and 2003.

Regards,
Padhu

[Killer42]

In Access 2003, set your default file format to Access 2000, that is whenever you create a file you it gets created in 2000 format, as mentioned by "Killer", Vb is compatible with Access 2000 and 2003.

Yes, VB can handle both. I just stick with 2000 format because I have the older version at home, and may need to take a DB file home some time. I suppose there's no reason to use the older Access 2000 file format, unless you have a specific need for it.

[nkechifesie]

Thank you all for your contribution. I really appreciate it and would get on it right away