Should you keep dbo_ names?

Posted on 2011-05-05
Last Modified: 2012-05-11
I had an Access database backend, that I converted to SQL Server backend.  Then I imported links to SQL database, all the tables now have "dbo_" added to their name... so when I try to run my forms none of them can find their recordsource.

Example form that had recordsource totblPeople now can't find the table because the link is named "dbo_tblPeople".  

Should I go into all my forms and rename the recordsources to match the new names or is there a better way around this?
Question by:gcgcit
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    I wouldn't recommend it.  I would change the local name of the linked tables.  If you right click on the table name, you should get a Rename option in the popup menu.  Select that and then just delete the "dbo_" portion of the table name.  This will not damage the link.
    LVL 47

    Accepted Solution

    If you have code that relinks tables for you, then you should set it up so that it creates the local table with the name you want it to use.

    Another way to do this, if you have a lot of tables is to write a quick subroutine:

    Public Sub DropTablePrefix()

        Dim db as dao.database
        Dim tdf as dao.tabledef

        set db = currentdb
        for each tdf in db.tabledefs

            if instr(, "dbo_") = 1 then
                tdf.Name = mid(, 5)
            end if


    End Sub
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    Make a backup before you do this!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    732 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

    22 Experts available now in Live!

    Get 1:1 Help Now