Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    1

    Unanswered: Re-create joins after DBO change in SQL Server

    Hello,
    This is my first post here, so please be kind.
    I have been given the task of modifying MS Access queries which have been running for 12 years against an MS SQL Server database.
    There are hundreds of linked tables and now I have to re-link and modify the joins.
    Is there a simple method to do this?
    When I modified the prefix from the original BGGT_ to DBO_ all the tables were successfully modified.
    However, when I attempt to open the queries to re-establish the joins, I receive errors.
    Some of the queries I was able to modify in Query view.
    Others I can not. I receive errors such as query too complex.

    Can someone please help?

    Many thanks,
    Mike

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Please read the error messages, deal with the messages that you understand, and then post both the offending SQL statements and the resulting error messages for the messages that you don't understand. Knowing that you're getting error messages only tells us that something is wrong, but it gives us no insight into what problem occurred or what caused that problem.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •