[MS_AccessPros] Re: Need to Move MS Access DB (hardcoded to SQL Server) to another SQL Server

 

James

Just relink the tables using the table link manager in the MDB. Once you create the new DSN file aimed at the new SQL Server instance, run the linked table manager. Be sure to check the "Prompt for new location" box at the bottom of the manager.

Then you will have to compile a new MDE.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

 

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (8)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___