Database - HELP

Hi i am creating a website which keeps a collection of cars for sale.  I am
using Visual Web Developer 2005 (express edition) to create this and am using a
MS Access 2003 database to store the cars (because hosting provider only
supports this).  However, I am finding difficulty in adding the database to the
project and connecting things such as the login panel and other things to this
database.

Can some one refer me to a tutorial having the steps on how to add a MS Access
database to a VWD project and linking it to the items such as login panel?  I
would also like the steps involving the connection string...

 

Thanks

Hi,

you can find such an article right here: Using Access instead of SQL server for
your ASP.NET Application Services.

Grz, Kris.

Great!!  exactly what i needed! 

 

Thanks very much Kris!!

Also another thing.  I would like to add another separate database to store the
car details.  Is there anyway to add another Access database to the file?  The
problem is that I wish to separate the details of the cars from the users/roles
etc.

Hi,

vbnetman:I would like to add another separate database to store the car details


Sure you can. Just add the other database and create a new connectionstring
element in the web.config for it. Actually most people just want to have
everything in the same database as it costs less when hosting it.

Grz, Kris.