Access 2007 Data Source in Vis Web Xpress 2008

Question

User699643714 posted

 I can't figure out how to connect to a Access 2007 accdb, doesn't appear to be an option in Visual Web Dev express 2008. I can connect to an 03 .mdb fine. Is it just a lack of a wizard to connect to 08? Is there a connection string I can use?

Thanks

Answer 1

User699643714 posted

 Did it through a SQL connection, seems to work perfect.

Answer 2

User-1199946673 posted

 Did it through a SQL connection, seems to work perfect.

 

Yes, that's the way. But remember that the new ACE.OLEDB driver isn't installed on a windows server by default unlike the old OleDB driver, so test if it works also in your production environment. Their is no real advantage in using Access 2007 files on a webserver, so if it doesn't work, I would recommend to use an MDB file, rather than installing the ACE.OLEDB driver