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.

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.

About Us

WSI is a small business and a leading provider of custom access programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom access development experts.