Can I reset an Access Database?

P

PSUSousa

After designing a database and trying some test data, I'd like to reset the
database. In other words, erase all records and reset all AutoNumbers, etc.
Is this possible? Seems like something easy that I'm just missing.
 
A

Albert D. Kallal

If you open each table, select all records...delete.

You then do a compact and repair (this will reduce and reclaim the empty
wasted space...and re-set the autonumbers).
 
K

Ken Snell [MVP]

Or just import all tables into a new database, and import the structure only
(no data).
 
A

Albert D. Kallal

Ken Snell said:
Or just import all tables into a new database, and import the structure
only
(no data).
Click to expand...


Gee..that is a *much* better suggestion...(even if you don't need to keep
the old data...the above is faster/easier/better).
 
S

Sylvain Lafontaine

The only problem with this method (the importation) is that the display of
the diagram for the structure of the database will get all mixed up.

S. L.
 
T

Tony Toews

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
please) said:
The only problem with this method (the importation) is that the display of
the diagram for the structure of the database will get all mixed up.
Click to expand...

Use the sysrels utility at the following location to copy the table
relationships layout window
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=12#12
Or use Save Restore Modify Relationship Window at
http://www.lebans.com/saverelationshipview.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
D

david epsom dot com dot au

The only problem with this method (the importation) is

And permissions, and owner permission queries, and database properties, etc

Of course, not problems unless they are problems :~)

(david)
 
T

Tony Toews

david epsom dot com dot au said:
And permissions, and owner permission queries, and database properties, etc
Click to expand...

FWIW I have a routine which sets all the database properties after an
import.
Of course, not problems unless they are problems :~)
Click to expand...

<smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
P

PSUSousa

So in other words, this seems like a basic feature that MS should add. Makes
sense... just a Database Reset button.. Where can one suggest such things?
 
Top