Membership & Role Management RRS feed

  • Question

  • User259483269 posted

    Anyway to use Access Database with Membership and Role Management system?

    Thursday, April 2, 2009 9:58 PM


All replies

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, April 3, 2009 1:56 AM
  • User259483269 posted

    [:D] thank you, been goign crazy looking for an example of this.

    Friday, April 3, 2009 6:53 PM
  • User259483269 posted

     Couple of more question about this. Does Access 2007 count towards Access Provider or as SQL provider? Would this method work with Asp.Net 3.5?

    Thursday, April 9, 2009 7:58 PM
  • User-1199946673 posted

    Access 2007 is also a Access Provider. However, you'll need to have the Microsoft.ACE.OLEDB.12.0 driver installed on the server. The connectionstring should be something like:

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|database.accd

    If you'll get the error

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

    It means that the driver is not installed, which in a hosted environment, where you're most likely in since you're using Access, is often the case.

    And yes, it will work with ASP.NET 3.5

    Friday, April 10, 2009 3:29 AM
  • User259483269 posted

    Thank you so much for the info and help guys.

    Friday, April 10, 2009 9:05 PM