Im using Access 2007 and it creates files with an .accdb extension instead of .mdb. Can I still use these files with my ASP scripts?
To be honest… this question caught me a little off guard. I had not yet installed Microsoft Office 2007 and had no idea that they had gone and changed the Access database file format. After a little digging, I found that yes you can indeed use the newer format with only minor changes to your existing code. The first step in getting your scripts working with the new format is to install the 2007 Office System Driver: Data Connectivity Components on your web server. This installs the components you’ll need (ODBC and OLEDB drivers) in order to read and write data to the new Office 2007 file formats. The next step is to change the connection string you use to connect to your Access database. If you’ve been using OLEDB to connect to your Access database then your existing connection string will probably look something like this: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\path_to_database\database.mdb; In addition to changing it to reference the new file, you’ll also need to change t
