Solved

UPsizing to SQL Server and Local Reference

Posted on 2011-03-05
2
303 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:ChuckRush
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 35043980
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
0
 

Author Comment

by:ChuckRush
ID: 35046215
Thanks Peter!

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
hyperlink data type in SQL 3 23
sql server tables from access 18 16
Query group by data in SQL Server - cursor? 3 28
T-SQL Default value in Select? 5 22
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now