By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Link to SQL Server Tables without dbo_ prefix.

P: n/a
How do link SQL Server tables to a Access front end without having the
dbo prefix?
I have to change the name of many tables.
For Examble: dbo_Customer to Customer.

Sep 2 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"to*******@msn.com" <to*******@msn.comwrote in
news:11*********************@k79g2000hse.googlegro ups.com:
How do link SQL Server tables to a Access front end without having
the dbo prefix?
I have to change the name of many tables.
For Examble: dbo_Customer to Customer.

for each file in the window
Click once on the name, press the F2 key, edit and press Enter
loop

programmatically
open the tabledefs collection,
loop through each tabledef in the collection,
.edit
tabledef.name = mid(tabledef.name,4)
..update
loop

for a hundred tables, the manual way is faster than writing and
debugging the code

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Sep 2 '07 #2

P: n/a

"Bob Quintal" <rq******@sPAmpatico.cawrote in message
news:Xn**********************@66.150.105.47...
"to*******@msn.com" <to*******@msn.comwrote in
news:11*********************@k79g2000hse.googlegro ups.com:
>How do link SQL Server tables to a Access front end without having
the dbo prefix?
I have to change the name of many tables.
For Examble: dbo_Customer to Customer.

for each file in the window
Click once on the name, press the F2 key, edit and press Enter
loop

programmatically
open the tabledefs collection,
loop through each tabledef in the collection,
.edit
tabledef.name = mid(tabledef.name,4)
.update
loop

for a hundred tables, the manual way is faster than writing and
debugging the code
Might want to check to assure they are linked tables before modifying the
name... or that they have the "dbo" prefix... Every production access
client DB using ODBC-linked tables that I've worked on had local lookup
tables, in addition to the linked tables.

Larry Linson
Microsoft Access MVP
Sep 2 '07 #3

P: n/a
"Larry Linson" <bo*****@localhost.notwrote in
news:obHCi.966$kI5.613@trnddc08:
>
"Bob Quintal" <rq******@sPAmpatico.cawrote in message
news:Xn**********************@66.150.105.47...
>"to*******@msn.com" <to*******@msn.comwrote in
news:11*********************@k79g2000hse.googlegr oups.com:
>>How do link SQL Server tables to a Access front end without
having the dbo prefix?
I have to change the name of many tables.
For Examble: dbo_Customer to Customer.

for each file in the window
Click once on the name, press the F2 key, edit and press Enter
loop

programmatically
open the tabledefs collection,
loop through each tabledef in the collection,
.edit
tabledef.name = mid(tabledef.name,4)
.update
loop

for a hundred tables, the manual way is faster than writing and
debugging the code

Might want to check to assure they are linked tables before
modifying the name... or that they have the "dbo" prefix... Every
production access client DB using ODBC-linked tables that I've
worked on had local lookup tables, in addition to the linked
tables.

Larry Linson
Microsoft Access MVP
So do the ones I see, but I left that to the OP as part of the
debugging. :-)

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Sep 3 '07 #4

P: n/a
Hi ???,

You can try my tool :
http://www.logicielappui.com/tips/Ac...ginMDB_SQL.zip
Best regards

Bob
<to*******@msn.coma écrit dans le message de
news:11*********************@k79g2000hse.googlegro ups.com...
How do link SQL Server tables to a Access front end without having the
dbo prefix?
I have to change the name of many tables.
For Examble: dbo_Customer to Customer.
Sep 3 '07 #5

P: n/a
"Logipro" <no*******@nowhere.comwrote
You can try my tool :
http://www.logicielappui.com/tips/Ac...ginMDB_SQL.zip
And, it might turn out to be legitimate, but downloading and executing
something that does not even go to the site before triggering the download
might be just a little risky.

Larry

Sep 4 '07 #6

P: n/a
Right !

But my Web Site was just in French : http://www.logicielappui.com/tips
Bob
"Larry Linson" <bo*****@localhost.nota écrit dans le message de
news:hu3Di.6921$3R5.5609@trnddc05...
"Logipro" <no*******@nowhere.comwrote
>You can try my tool :
http://www.logicielappui.com/tips/Ac...ginMDB_SQL.zip

And, it might turn out to be legitimate, but downloading and executing
something that does not even go to the site before triggering the download
might be just a little risky.

Larry
Sep 6 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.