I wrote a program that connected to a Microsoft Access 2000/2003 mdb file and accesses the data. It works fine, but I'm wondering if there is a way to connect to Access 2007? If I change my connection string, will my program work with access 2007 or is it more complicated then that? And if it will work, can someone provide an example of an Access 2007 database?
+3
A:
You will need to download the 2007 Office System Driver: Data Connectivity Components (doesn't require Access 2007 installed). Then changing the connection string to point to the Access 2007 database should be sufficient.
Useful site: ConnectionStrings
Mitch Wheat
2009-07-04 03:53:38
A:
Your question is very poorly worded. Access 2007 offers two different file format, the traditional MDB format, and the ACCDB format. If you use MDB format, then you don't need any additional drivers, as it's the same format in 2007 as in previous versions (and might be compatible back to Access 2000, since that's the default format for all versions from Access 2000 to 2003). You need the additional data connectivity components if you choose the ACCDB format. There is little reason to do so, as most of the new features of ACCDB are there in order to be compatible with Sharepoint.
David-W-Fenton
2009-07-04 21:54:28
A:
I'm writting an apliccation which needs access to database in MS Access and I want to edit and change some fields in it. Is that possible if I know structure of that database? And how can I do that?
Zarson
2010-05-07 10:37:39
This is not an answer. It is a new question. You should post a new question, since very few people are likely to see it buried here as it is in this ancient question.
David-W-Fenton
2010-05-07 19:18:15