I created a database using Access 2007.
I am now trying to connect to that DB using VB.Net 2003 code (Visual Basic).
I cannot connect to the database.
I think it has something to do with the fact that Access 2007 database
files end with the extension .accdb instead of .mdb.
The code that I used to creat a connect to open a similar DB using an older version of Access(Access 2000?) does'nt work (after changing the .mdb file extension to .accdb in the path to the DB).

I can't figure it out. Can anyone please help?

thanks

JohnBoy

Hello John,

Take a peek at this link

 http://daron.yondem.com/PermaLink.as...a-aba91d24b315


Below is the text.

The new office suite version 2007 comes with brand-new file formats. One of them is the new Access database format version 2007 with accdb extension. Of course there is a new connection string for those new access databases. You can use the connection string below to access your accdb databases through asp.net.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database1.accdb;Persist Security Info=False;

In addition, if you are using passwords to access your database, you can include it in your connection string like below;

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database1.accdb;Jet OLEDB:Database Password=MyDbPassword;

However, your hosting provider will not be aware of this upgrade or probably you don't want to install Access 2007 on your server. Actually, you don't need to. Just install 2007 Office System Driver: Data Connectivity Components..

Hope this helps.





Thanks,

John