re-use a DB by emptying records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use a colleagues DB for my own project. The DB has many tables in
it with many links and a primary key. How do I empty the DB so I can use it
for my project. When i go to some of the tables and select all records and
select delete I get lots of error messages.
 
The developer may have set up referential integrity which suggests a child
record can't exist without a parent record. If you try to delete the parent
record prior to the child record, this would leave an "orphaned" record which
Access won't allow.

You may need to simply delete the records from child tables prior to
deleting from the parent table.
 
Back
Top