Removing access records to start from scratch

S

Shawn

Hello all,
I am using the service call management access database template. It has
sample entries, I would like to remove all, employee, part , customer, and
workorder entries to start with a scratch database. Is there an easy way to
do this.? thanks in advance. Shawn
 
T

TedMi

For every table, run the query:
DELETE FROM [nameoftable]

But a safer approach, which maintains the sample entries for later use, is
as follows:
Edit -> Copy a table
Edit -> Paste, selecting structure only, give the table a new name
Repeat for each table.
Rename the old tables
Rename the new tables with the names of the old ones (so queries and reports
work).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top