Link to SQL Server Tables without dbo_ prefix.

[tomlebold]

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.

[Bob Quintal]

"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

[Larry Linson]

"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

[Bob Quintal]

"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

[Logipro]

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.

[Larry Linson]

"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

[Logipro]

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