re-use a DB by emptying records

[trix400]

I want to use a colleagues DB for my own project. The DB has many (10 to 15)
tables with many relationships and a primary key. When I go to individual
tables and select all rows and then select Delete I get lots of error
messages. Do i save the DB as a Template? and if so, how do I do that?

 

[Larry Daugherty]

Open a new, blank mdb. Get external data|navigate to old mdb & select
it.
Step through each type of object, selecting all in each case
and import 'structure only'

HTH
--
-Larry-
--

I want to use a colleagues DB for my own project. The DB has many (10 to 15)
tables with many relationships and a primary key. When I go to individual
tables and select all rows and then select Delete I get lots of error
messages. Do i save the DB as a Template? and if so, how do I do

that?

 

[Dale Fye]

If you have some lookup tables you should import the structure and the data.
If you do it this way, you will also have to recreate the relationships
exactly the way your coworker had them setup.

This can be time consuming, and if he has relationships designed into the
database, it will result in the errors you mentioned, if you try to delete
data from tables in the wrong order.

Personally, I'd just take a look at the relationships diagram in the
original (your copy) of the database. Identify which tables are the lookup
tables, and don't delete the data from them until the end (if at all).
Identify the tables that have links to the lookups, and delete the data from
them first.

HTH
Dale

 

[Klatuu]

You can import relationships during the import process.
Click on Options in the Import Objects dialog. You can select
Relationships, Menus and Toobars, and Import/Export Specs. This is also
where you would select Definition and Data or Definition Only. You want
Definition Only in this case.

 

[Dale Fye]

Thanks, Dave.

It's been a while since I have done a complete import, now that you mention
it, that is where you go to get the import specifications too.

Dale