ACCESS Help with System DSN

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • LilyRousseau
    New Member
    • May 2006
    • 7
    #1

    ACCESS Help with System DSN

    :confused: I could really use some help


    A Access Database was created and put out in a shared drive--so that anyone could run these queries.

    I copied the db and made some changes and created a new db by adding two new tables and creating a subquery to run with all the current queries.

    My problem is that now no one can use the queries. The run fine on my machine..and a selected few other machines.

    When viewing the link table manager I find that the old db looks like this

    example A link table R_b_A_detail ()

    and mine now show the following

    example B link table R_b_A_detail(DS N=op01rtdb02;)

    I have been told that example A are pass thru queries???? The db shows them as select queries.


    How can I change the new tables I added to look like example A?

    Thanks to anyone who can help....

    Lily
    Tags: None
    • wlc04
      New Member
      • May 2006
      • 70
      #2
      Did you split the db or the users accessing through shortcuts?

        Comment

        • LilyRousseau
          New Member
          • May 2006
          • 7
          #3
          Originally posted by wlc04
          Did you split the db or the users accessing through shortcuts?
          What I did was link two new tables the ones with the (DSN XXXX), The other linked tables have just a () after them.

          When I added the tables and rewrote the queries. They get an ODBC error message and are unable to run them. However, if you have set up in your control panel the odbc the data source dsnop01rtdb02 then you can run them. How do I change the two tables that I linked to be like the ones that were already in the odbc with just the () after them. All I can think of is it has to be the way I linked up the tables.

          thanks!

            Comment

            • wlc04
              New Member
              • May 2006
              • 70
              #4
              hmmmmmmmmmm...

              you might try to relink to the data and see if that helps. in the mean time I'll see what I can find out for you.

                Comment

                • wlc04
                  New Member
                  • May 2006
                  • 70
                  #5
                  This one was tricky for me. I've never linked to tables the way you are doing it. I found a link that might help you, though...

                  Microsoft Support
                  http://support.microsoft.com/?scid=kb;en-us;287414&spid=2509&sid=49
                  Microsoft Support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows 11, Surface, and more.


                  Good Luck - let me know how it works out..
                  :)

                    Comment

                    • LilyRousseau
                      New Member
                      • May 2006
                      • 7
                      #6
                      Thank you so much I appreciate your help...I got it to work with some tweaking and your great find!

                        Comment

                        Previous template Next
                        Working...