Status: Solved
Priority: Medium
Security: Public
Views: 365
Last Modified: 2012-05-11

UPsizing to SQL Server and Local Reference

I have an enternal Access accb that contained all of my tables for a front end applicaition. I upsized those tables to a SQL Server. When I set up the link to the front end to the SQL server, it appends dbo_ to the table name. Is there a way to keep thios from happening when setting up the link? I don't want to have to locally rename all of the tables fro all users.

Thanks

ChuckRush

Asked: 2011-03-05

Advertise Here

1 Solution

LVL 77

peter57rCommented: 2011-03-05

Won't you be re-issuing the front-end ? You're bound to have to change it in some ways to use a SQL server backend. So you only have to rename the tables once in your development front-end.

But you could write code to rename all the tables to exclude the dbo prefix.

untested...
dim tdf as dao.tabledef
for each tdf in currentdb.tabledefs
if left(tdf.name, 4) = "dbo_" then tdf.name = mid(tdf.name, 5)
next tdf

ChuckRushAuthor Commented: 2011-03-06

Thanks Peter!

I used this in conjunction wi th docmd.rename. I somehow thought that there was a hidden step that i was missing.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

UPsizing to SQL Server and Local Reference

Join & Write a Comment Already a member? Login.

Featured Post