• tables disappeared! (Acc2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » tables disappeared! (Acc2000)

    Author
    Topic
    WStmorken
    AskWoody Lounger
    April 2, 2003 at 5:04 pm #385615

    I am going nuts. I have a few tables that I copied, pasted back into the table list and renamed. I kept the old tables until I can redo some of the links. Now, I can see the renamed tables in the table link manager, but they don’t show up in the table list of the back-end database. Any ideas?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      April 2, 2003 at 5:21 pm #665798

      Where did you copy, paste and rename the tables? If you did this in the frontend database, you have only been copying the links to the tables in the frontend, not the physical tables in the backend. If you want top copy tables in the backend, you’ll have to open the backend directly.

      Reply | Quote
      • WStmorken
        AskWoody Lounger
        April 2, 2003 at 6:06 pm #665818

        No, this is all done on the backend. In the linked-table manager I can see both the original table and the renamed table (and both have the same path), and when I refresh the link it says it’s ok. Then I go look on the actual back-end and the renamed table is not there. A big mystery!

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          April 2, 2003 at 6:36 pm #665824

          How did you manage to rename the table in the backend if you can’t see it?

          Reply | Quote
        • WSMarkLiquorman
          AskWoody Lounger
          April 2, 2003 at 6:50 pm #665828

          If this was all done in backend, how come you have both tables in the frontend?

          Reply | Quote
          • WStmorken
            AskWoody Lounger
            April 2, 2003 at 6:59 pm #665832

            Hmmm, a little confusion here.
            The original table is on the back end, as are all the tables.

            There are NO local tables on the front end. You see the LINKED tables on the front end.

            I renamed the tables on the back end and then linked to them from the front end.

            Both the original and renamed tables show (as linked tables) on the frontend, and the paths in the Linked table manager show the same DB path.

            But , while the original table still shows when the back end is opened, the renamed table does not.

            Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 2, 2003 at 7:04 pm #665835

              If you select Tools/Options… (in the backend database), View tab, and check both Hidden Objects and System Objects, can you see the renamed tables?

              Reply | Quote
            • WStmorken
              AskWoody Lounger
              April 2, 2003 at 7:05 pm #665836

              I tried that – no luck. I’m beginning to think I have a phantom file on a server somewhere. I searched all my LAN drive for files of the same name and came up empty on that too.

              Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 2, 2003 at 7:21 pm #665839

              Very strange…

              Two more things to try:

              Activate the Visual Basic Editor (Alt+F11)
              Activate the Immediate window (Ctrl+G)
              Type DoCmd.SelectObject acTable, “YourTable”, True then press Enter, with one of the phantom table names substituted for YourTable. If you get no error message, switch back to Access. The instruction should select the table in the database window.

              Activate the Immediate Window in the Visual Basic Editor again.
              Type DoCmd.OpenTable “YourTable” then press Enter, with one of the phantom table names substituted for YourTable. If you get no error message, switch back to Access. The instruction should open the table.

              If you do get error messages, what are they?

              Reply | Quote
            • WSMarkLiquorman
              AskWoody Lounger
              April 2, 2003 at 7:39 pm #665843

              In the frontend, do you see linked tables for both the old and new tablesnames? If so, how did you do that?

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              April 2, 2003 at 8:50 pm #665872

              Tell me, is this your scenario.
              You have tables A, B and C on the backend and they are linked on the frontend. What you see on the frontend is A, B and C as linked tables.
              Then you change the table names on the backend, A to AA, B to BB and C to CC.
              What you now see on the frontend at this stage is still A, B and C.
              Then you link the tables AA, BB and CC to the frontend.
              What you then get is A, B and C as well as AA, BB and CC on the frontend.

              This is all ok, as A links to AA, B links to BB and C links to CC. I think you will find this is how it works. Of course I may be completely wrong as I have not tried this.

              Or am I completely wrong in this assumption.

              Pat

              Reply | Quote
            • WStmorken
              AskWoody Lounger
              April 3, 2003 at 6:00 pm #666119

              “problem” solved. I was explaining what someone told me they did. Turns out to be a bit different. They copied. pasted and renamed the linked tables on the front end only, so the renamed linked tables point at the original table. No new table was made on the back end. Frankly, I didn’t know you could do that! Anyway, I finally figured that out when I realized the “renamed” table on the front end was fully up-to-date with the original table, and then questioned how that could be so. The person who did it finally explained to me exactly what he did when I sat him down and went through it on the screen. Maybe I assumed too much when he first told me what he did and didn’t get enough details.

              Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 3, 2003 at 7:14 pm #666142

              laugh That was my first thought – see my first reply in this thread…

              That’ll teach you to accept uncritically what a user tells you!

              Reply | Quote
    Viewing 0 reply threads
    Reply To: tables disappeared! (Acc2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.