Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
COURSE of the MONTH
11 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
UPsizing to SQL Server and Local Reference
Posted on 2011-03-05
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
Thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses
Course of the Month11 days, 11 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.