how do I build a new database deleting only some information

[Guest]

I have a large database that I want to keep, but make a new copy deleting
only one kind of information, any ideas??

 

[Brendan Reynolds]

That rather depends on what you mean by 'only one kind of information'. In
the absence of that information, my best guess is that probably creating a
new, empty database and copying the objects you want from the old one might
be the easiest route. Be sure to click the 'Options' button on the Import
Objects dialog box - one of the options is to import tables including the
data stored in the tables, or just the structure of the tables without the
data.

 

[Dave]

well, first you make a copy, then you delete the one kind of information out
of the copy.

 

[inews]

You might also copy the relevant mdb file using windows explorer then
run a delete query. That would work best if it is records of a
specific type you want to delete rather than entire tables.