locked
SQL Server vs Access Databases RRS feed

  • Question

  • User482458310 posted

    I have a small website.  My host provider supports Access databases but not SQLserver (unless I go for a dedicated server).  I have looked around and find pretty much every shared host offering seems to support only MySQL or Access (not SQLserver).  Some of the Visual Studio 2005 features (like membership/login controls and wizards) assume SQLserver, and do not seem to support Access. 

    What's the reason that Access is downplayed while at the same time most shared-host offerings do not support SQLserver? 

    And -- is there a way to utilize the Membership tools while using an Access database to store user info?

    And -- any host providers out there that do support SQLserver on a shared basis?  (I.e. at modest cost).

     

    Thanks much!

     

     

    Sunday, April 20, 2008 8:09 PM

Answers

  • User77042963 posted

    Scott Mitchell has a walk through for how to use the membership in ASP.NEt 2.0 with an Access database. Here is the link to 4guysfromrolla.com:

    http://aspnet.4guysfromrolla.com/articles/010307-1.aspx

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, April 20, 2008 9:07 PM
  • User-821857111 posted

    Depending on the scale of your site, Access may well be good enough.  I would be so bold as to suggest that any site that is deployed in a shared hosting environment is going to be fit to use Access.  Limno has pointed you to Scott Mitchell's article - here's another  very good one from Imar Spaanjaars: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=404

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 21, 2008 2:38 AM

All replies

  • User77042963 posted

    Scott Mitchell has a walk through for how to use the membership in ASP.NEt 2.0 with an Access database. Here is the link to 4guysfromrolla.com:

    http://aspnet.4guysfromrolla.com/articles/010307-1.aspx

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, April 20, 2008 9:07 PM
  • User-821857111 posted

    Depending on the scale of your site, Access may well be good enough.  I would be so bold as to suggest that any site that is deployed in a shared hosting environment is going to be fit to use Access.  Limno has pointed you to Scott Mitchell's article - here's another  very good one from Imar Spaanjaars: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=404

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 21, 2008 2:38 AM
  • User482458310 posted

    Thanks guys for the guidance.  I can't wait to see how the Membership stuff works with Access using my web host.

    Dick

    Monday, April 21, 2008 10:09 AM