Forum Discussion

Phil_Tremper's avatar
Phil_Tremper
Copper Contributor
Aug 31, 2021

Coping Access tables

I was trying to distribute my data into multiple named tables within Access. I made a copy of the table and renamed it. Then in the copied table I remove the data I did not need in the copied table. ...
access
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Sep 01, 2021
Did you get a link to DropBox?
Phil_Tremper's avatar
Phil_Tremper
Copper Contributor
Sep 02, 2021
Yes. I just got to it. It went of junk. I put the zipped access file done. I renamed it to Horses - Old. This process has taught me some things about Access. I'm sure that what I did was related to the fact that all the tables in the file were marked as related. When I brought my back down and copied the table that was corrected, all the related markers disappeared and when I ran my program to create the missing data my program ran about 10 times faster. Anyway, the tables in question are labeled SARATOGA, SARATOGA_2010, SARATOGA_2011. They are all blank as far as I can see. My primary problem is that when I tried to eliminate the data from the 2011 file, it removed all the data in all three tables and from the off line backup copies. i do not know how that can happen.
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Sep 02, 2021

    Phil_Tremper 

     

    Perhaps a screenshot will be useful. See the little arrow to the left of the table icon? That tells us "Linked Table". I.e. all we have is a link that tells Access where to find the real table.
    And, when you hover the cursor over the table in the Navigation Pane (or in the database container in Access 2003 and earlier), Access shows you the actual location of that mdb containing the real table.

     

    • Phil_Tremper's avatar
      Phil_Tremper
      Copper Contributor
      Sep 02, 2021
      I have used that. Again the problem occurred when I made a copy of the table: SARATOGA. Pasted it to the table, rename the pasted copy of SARATOGA to SARATOGA_2010 and then opened SARATOGA_2010 and deleted all but data in 2010. When I went back to SARATOGA which was never specifically opened, All the data was missing in SARATOGA.
      • George_Hepworth's avatar
        George_Hepworth
        Silver Contributor
        Sep 02, 2021

        Phil_Tremper 


        To be sure we're on the same page.

         

        You opened "Horses_be.mdb" in the vs2019 folder. Correct?
        You copied and pasted the table called SARATOGO in THAT mdb. Correct?
        You then deleted records from the copy called "SARATOGO_2010". Correct?

        And all of this was NOT done in the copy of the mdb you sent to me. You did all of this in that other mdb, the one called "Horses_be.mdb" shown as the linked mdb in my screenshot?

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Sep 02, 2021

    Phil_Tremper Thank you. I just downloaded the mdb. I'll review it and come back with any suggestions. It'll be a little while, but sometime today.