Hello, I have recently upgraded MS office to Access 2007 which is using its native format for access databases as .accdb and not .mdb as it it has used to.
when I used ASP runner Pro - I have generated the application and it worked PERFECTLY on my machine. I repeat, perfectly.
however when I have uploaded it to my server (corporate) i got server 500 error.
I was stumbled, and only after I have saved my access database from accdb into mdb format and regenerated the application and uploaded it to corporate server it worked again.
My question is: is that the correct procedure(resave access database into older format and then run the project), or I can use the new format in office 2007?
Or is there a way change settings on the corporate server to allow accdb format? If yes please let me know.
Thanks
you'll likely need the access runtime installed on the server which will update ODBC as well - else define the appropriate office 2007 mime types on the server but I doubt it would work without the run-time libraries for access 2007 installed on the server.
this may help generating the correct mime types and install required libraries without having to install run-time since you are not "running the db on the server, just accessing it: http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
"Instructions
To install this download:
Download the file by clicking the Download button (above) and saving the file to your hard disk.
Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
Follow the instructions on the screen to complete the installation.
To use this download:
If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
If you are connecting to Microsoft Office Excel data, add “Excel 12.0” to the Extended Properties of the OLEDB connection string.
If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (.mdb, .accdb)};DBQ=path to mdb/accdb file”
If you are application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (.xls, .xlsx, .xlsm, .xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
"