MUST  Removing the DBO prefix in Linked tables

Here is some code to strip out the DBO prefix on SQL Server linked tables

Standard version of MUST

Private Sub cmdRenameTables_Click()
'Code to move through the (linked) tables that have been created
'with a SQL server upsize and rename back to their original name
'designed for the DNO owner names

Dim tbl As dao.TableDef

For Each tbl In CurrentDb.TableDefs
  If Left$(tbl.Name, 4) = "dbo_" Then
    tbl.Name = Mid$(tbl.Name, 5)
  End If
Next
End Sub

 Return to the Orders page

 

 About MUST

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.

Garry Robinson
Office Access MVP from Australia

What do you need?

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.