I'll throw in my 2 cents as well. If I were in your position I would use the Microsoft utility to convert and dump your access database up to the SQL server and then convert your Microsoft Access front end (for the time being) to ADO to ensure you are working properly with SQL. If you are using Access 2000 then the convert utility for SQL server is built right in (I believe anyways). Otherwise download the Access97 utility from Microsoft.