Last post Apr 21, 2008 10:09 AM by uick383937
Apr 20, 2008 08:09 PM|uick383937|LINK
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).
Apr 20, 2008 09:07 PM|limno|LINK
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:
Apr 21, 2008 02:38 AM|Mikesdotnetting|LINK
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:
Apr 21, 2008 10:09 AM|uick383937|LINK
Thanks guys for the guidance. I can't wait to see how the Membership stuff works with Access using my web host.