locked
Access 2007 Data Source in Vis Web Xpress 2008 RRS feed

  • 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

    Monday, August 24, 2009 1:24 PM

Answers

  • User699643714 posted

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 24, 2009 2:18 PM

All replies

  • User699643714 posted

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 24, 2009 2:18 PM
  • 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

    Monday, August 24, 2009 3:05 PM