var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Resetting Database?
Is it possible to remove all of the data from your database and just leave the structure? I would prefer if all of the autonumbers began at 1 again and it was just like starting from scratch.
I don't know of a way to do a mass update, but if you copy a table and then paste the table into the database, it gives you the option of pasting just the structure. That would create an identical table to your original but with no data and your AutoNumber would begin at 1.
Perfect Thanks RDB thats just what I was looking for.
If you do compact & repair with no data in your tables auto numbers will be reset as well without copy and past structure.
<<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
Agreed with Aran1. Just empty the tables and then C&R and you're done.
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "