You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Access MVP Bob Larson has released a utility that you can use to clear test data from your database. I’ll let Bob tell you about it:
It is a “database reset tool” which is for anyone who has been developing a database and they’ve got test data in it and want to get it prepped for release. It allows you to browse to the database file, and automatically opens a form with a list of the tables that are in the database (not system tables), then you can delete any of the tables from the list that you don’t want cleared (such as lookup tables) and then you close the table list and then click the RUN button (Green Light Icon). It will then clear all of the selected tables and then compacts it to reset any autonumbers. It is a fairly simple tool, but it can make resetting the database a very quick and painless job.
It is a “database reset tool” which is for anyone who has been developing a database and they’ve got test data in it and want to get it prepped for release. It allows you to browse to the database file, and automatically opens a form with a list of the tables that are in the database (not system tables), then you can delete any of the tables from the list that you don’t want cleared (such as lookup tables) and then you close the table list and then click the RUN button (Green Light Icon). It will then clear all of the selected tables and then compacts it to reset any autonumbers.
It is a fairly simple tool, but it can make resetting the database a very quick and painless job.
You can download the tool from Bob’s Free Access Tools page:
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx
Enjoy!
Comments: (4) Collapse
Hrm.. downloaded and ran this. You may want to mention that it only lets you select MDB, not ACCDB files.
Lee: I'll fix that ASAP. Sorry about that. It was an oversight on my part.
I've modified the filter for selecting the database type and uploaded the new file. Let me know directly if you run into any other problems with it. My email is located on the website under the CONTACT ME link.
A quick update about this tool... I just uploaded a revised version which will 1. Let you choose MDE or ACCDE files as well as MDB or ACCDB files. 2. Let you SAVE your table list (so once you have deleted the tables you don't want cleared, you can save the list and the reload it again later so you don't have to delete all of the tables you don't want cleared again). 3. Added checkboxes to select the tables to remove from the list so you can quickly select them and then hit a delete button that deletes all of the selected.
Comments: (loading) Collapse