Can I reset an Access Database?

[Guest]

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.

 

[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).

 

[Ken Snell [MVP]]

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

 

[Albert D. Kallal]

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

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

 

[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.

 

[Tony Toews]

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam

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.

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

 

[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)

 

[Tony Toews]

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

FWIW I have a routine which sets all the database properties after an
import.

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

<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

 

[Guest]

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?