Private Sub cmdRenameTables_Click()
The product that we are talking about here is called MUST, an Access tool developed by Andy Couch, a fellow Access MVP.
To use the product you place the MUST MDE file in the same folder as your Access database(s), open it up, identify Access, nominate your SQL Server database and you are away.
Office Access MVP from Australia
To make this upsizing software work, you will need Access 2000, XP, 2003 or 2007 and you will need SQL Server 2005 or 2008 or 2000 and you will need Administrator rights on that server.
For MUST+Web you will need Visual Studio 2005 or 2008
The best way to find out about the software is to view our videos or download and try the trial version.