MS Visual Studio Express - Login with AccessDataSource

[McKilty]

Hello,

First off, if this turns out to be the wrong place to be posting this,
kindly redirect me to where I should be posting this.

I am a long-time off and on VB programmer. I started with Access 97
and moved on to VB6. I've done some VBA and VB script in ASP pages.
I recently moved to Visual Studio to do some VB.Net work so I am quite
new.

I am in the process of converting (recreating) my existing database to
Visual Studio from FrontPage/Expression Web. I have the Express
version of the software, so perhaps I am missing tools that would help
with this problem of mine. Okay, enough preamble...

PROBLEM
When I started a new project in VS, it gives me a folder called
ACCOUNT with multiple pages for logging in, registering, changing
passwords, etc. This creates an SQL database which has all the work
done for me. Unfortunately, I'm pretty sure I cannot use SQL on my
server or at least not without upgrading my hosting plan. I need to
use MS Access, but I have no idea how these login forms are linking to
the SQL tables.

Is there a way I can switch it out to use Access? Is there a template
or setting I could have used that would have set it up for Access? Is
there a place I can go to download this type of thing?


I know the SQL is the much preferred database over Access. I get
that. MY website is small and I don't ever expect to have a lot of
users. I am kind of interested in moving to SQL, but I don't know
that I could just publish to my host website (myHosting.com) even if I
did upgrade.