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