Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

UPsizing to SQL Server and Local Reference

Posted on 2011-03-05
2
Medium Priority
?
349 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 1000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

580 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