January 24, 2012 at 12:00 pm
Is there anyway to get rid of the "dbo." prefix that is attached to SQL table names in Access?
January 24, 2012 at 12:04 pm
What happens when the schema is not dbo?
Jared
CE - Microsoft
January 24, 2012 at 12:14 pm
When you're in a MDB file, the label attached to the names (e.g. dbo_table1) are just that - arbitrary labels. Once you've attached the tables the name itself doesn't matter. (the phyical conneciton to the SQL tble is maintained regardless of the name on the label).
The easiest way to do it is to create a simple script that cycles through the TableDefs array, doing a find and replace on the names of the tables. Might as well save it since you might need to rerun it if you reattach tables or need to relink everything.
In an ADP file (access data project) - that's a direct reflection of the object in the DB. You won't be able to remove the schema notations in that scenario.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply