Microsoft Access Remove dbo From Table Name | dbo_ Linked Table

Function to Remove the dbo Prefix on Linked Tables

This handy function will go through and remove any tables that have a prefix of "dbo_" in the Access program. This is a handy function, especially if you are working with a migrated Access database to SQL server. When you relink to the sql tables, they come in with a prefix (usually dbo_), making all your existing forms and reports fail. By removing the prefix, the forms and reports will work without any modification.

Public Sub Remove_DBO_Prefix() Dim obj As AccessObject Dim dbs As Object Set dbs = Application.CurrentData 'Search for open AccessObject objects in AllTables collection. For Each obj In dbs.AllTables 'If found, remove prefix If Left(obj.Name, 4) = "dbo_" Then DoCmd.Rename Mid(obj.Name, 5), acTable, obj.Name End If Next obj End Sub

If you need any help implementing this function or modifications made for your needs, to get a free quote for your Microsoft Access Development needs. 

To learn more about the WSI quoting process.