Deleting a table in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shanandoor - 27 Jan 2008 21:29 GMT

Hi i am trying to delete an old table in access. I have put a new table in
and the old table will not delete because it is a replica which I think
happened when I was trying to use the briefcase going between different
computers. I now cannot delete it - can anyone help

Reply to this Message

John W. Vinson - 27 Jan 2008 21:49 GMT

>Hi i am trying to delete an old table in access. I have put a new table in
>and the old table will not delete because it is a replica which I think
>happened when I was trying to use the briefcase going between different
>computers. I now cannot delete it - can anyone help

You will need to "unreplicate" the database, by recovering the Design Master
(if you can). Unreplicating can be a difficult and finicky process! Get a copy
of the Replication FAQ:

http://support.microsoft.com/kb/282977/en-us

for starters.

You may be better off creating a new, empty database and using File... Get
External Data... Import to import the tables and other objects from the
replicated database. Even at that the tables will have replication-specific
fields which will be (at best) useless.

John W. Vinson [MVP]

Reply to this Message