Question Use Access 2003 or 2007 wizard to move backend to SQL 2005?

[treva26]

Hi,

I have a MDB (Access 2003) database frontend and backend and I want to move the backend onto our new SQL 2005 server.

I know I can use the wizard in Access 2003 to do this, but would it be a better idea to use the wizard in Access 2007? Im just thinking maybe they fixed a few bugs since 2003 or something..

Most users will still be using 2003 as a frontend.

Thanks.

 

[boblarson]

I would think you can just do it in 2003. Just make sure to use the correct SQL Server driver for the ODBC connection (SQL Native Client, unless you are on Windows Vista and then it would be the normal SQL Server driver).