VB 2003/2005 and Access 2007

[JuggaloBrotha]

Has anyone had any problems with a VB 2003 or VB 2005 program using an Access (*.accdb, not *.mdb) database?

Right now we're using Access 2003 (*.mdb) databases, but our unit is considering using Access 2007 (*.accdb) databases with VB 2003/2005.

 

[cjard]

No such thing as an Access Database...

..it's a jet database, and Access and your apps can work it because of Jet drivers installed. If Jet can handle .accdb then is no problem.. or if some other driver is needed and exists usable with vis studio then also, no problem.. If accdb is proprietary and closed and no drivers exist, youre lost..

 

[JuggaloBrotha]

There is a set of components that contains Jet drivers for the database:

http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en