Hello Everyone,

I am very new to ASP and Dreamweaver.

I am trying to create an ASP page using Dreamweaver that links to a Mircosoft Access 2000 database(database is currrently on my laptop).

I am unclear how to properly create and use a connection(ADODB?) to my database.

Also is it possible to create an ASP page that would link to a database on my laptop, so that I could to my development locally. Then move my database to a server and change the database connection code as necessary?

Any help is greatly appreciated.

Regards.

CrazyCanuck

You can take a look at this tutorial and examples to be clear about ADO Connection and recordset.
ADO Recordset

ADO Tutorial - This has got many examples and a demo link too(on the left-hand side menu).

Yes, you can do that locally and later when needed to shift that to another server, you will have to change the connection string there if needed.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Hi Vijay,

Great. Thanks for the links and advice. I'll try then out and lrt you know how it goes.
Thanks Again.

CrazyCanuck