Access 2000 with MSDE

[Jimmer]

I have decided to convert from using DAO to ADO and to upgrade to and Access 2000 database instead of Access 97.
I think that I will use the MSDE data engine instead of the Jet 4.0 database engine. But I am not sure whether its just changing the connection type in code, or whether I need to actually change the access 2000 database in some way???
Any thoughts????

Thanx in advance

[Gary.Lowe]

Jimmer

I as I understand using MSDE is basically a small version SQL server database so you don't need to use access at all.

Because it is SQL Based you don;t have to do alot to upgrade to SQL server itself at some point in the future.

I may be wrong though :(

Gazza