Hi Kathi,

the upsize wizard has been a great tool for me also, but I like to give a tip before you use it:

Be sure all tables have a primary key otherwise they won't be updatable after the upsize while in Access they were.

DAO still works fine with linked SQLServer or Oracle tables except for recordsets of type dbOpenTable they are not allowed, you can use dbOpenDynaset in stead. In fact using linked tables means you use DAO.

Thanks

Jan