Remove dbo_ From Table Names

Lynn_AccessUser

Registered User.
Local time
Yesterday, 22:05
Joined
Feb 4, 2003
Messages
125
I am linking sql tables to an Access frontend. As a result all my table names start with dbo_TableName. I have to go back and manually delete dbo_ every time I relink the tables (for whatever reason refreshing the links does not work every time which is another issue in itself).

What I am looking for is some code that when run will remove dbo_ from the table names. Thanks!
 

Users who are viewing this thread

Back
Top Bottom