Results 1 to 2 of 2
  1. #1
    Linda is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2009
    Posts
    10

    Problem - Objects Pointing to Table Copy

    I created a copy of a table and copied my records into it, but some of the relationships/queries/forms/reports are still pointing to the original table. I would like to delete the old table, but want to clear up this confusion first. What is the best way to handle this?



    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    With a BACKUP, delete the table and then rename the new table to the old table name then try it. Did I say use a BACKUP?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-06-2011, 04:18 PM
  2. Replies: 2
    Last Post: 04-02-2010, 07:42 AM
  3. Replies: 0
    Last Post: 10-15-2009, 02:08 PM
  4. copy data from text file into table in access
    By miziri in forum Programming
    Replies: 3
    Last Post: 08-12-2009, 03:02 PM
  5. Making a backup copy of table or database
    By wasim_sono in forum Access
    Replies: 0
    Last Post: 03-09-2006, 05:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums