Migrating Access 2003 ADP from SQL 2005 Express to SQL 2005 vertual server

[ak_ls]

I have an Access 2003 APD project that currently runs on SQL Server 2005 Express with no other named instance on the same computer. Now, I have to migrate this project to SQL 2005 vertual server.

Can somebody tell me with the possible issues and resolutions if the vertual server is a named instance of SQL Server 2005?

One issue I know is that every client computer must have MDAC 2.71 or later version installed.

Please help me to prepare ahead of encountering the issues.

Ashok

 

[SQL_Hell]

Changing from sql express to a named instance of sql2005 should make absolutely no difference at all provided you remember to copy everything across such as logins for example.

SQL express is always MSSQL$SQLEXPRESS which is named instance anyway.