template basics

[Guest]

Hi,
I've downloaded a template that i think will be really useful, but i can't
find any help on just doing the basics. eg how do i delete the sample data
without messing up the primary key numbers? and where do i get help on what
the template is actually doing in terms of functions? There's lots of help
for advanced questions, but i just need to know the basics!! If anyone could
give me a hand that would be great. FYI it's the Access Event Management
database template.
thanks

 

[Guest]

Hi Julie,

What do you mean by "without messing up the primary key numbers"? Don't be
afraid to try something--all you need to do is restore from a backup copy (or
download another copy) in case you mess something up. I just downloaded a
copy of this database, and the primary keys are all autonumbers. An
autonumber is a meaningless number. Don't worry about the fact that gaps may
develope in the sequence. An autonumber is not intended to provide a count of
records.

If you delete *all* records from a table with an autonumber, and then you
compact the database (Tools > Database Utilities > Compact and Repair
Database), the autonumber will start over at 1 for a new record that you
enter.

Tom
____________________________________

:

Hi,
I've downloaded a template that i think will be really useful, but i can't
find any help on just doing the basics. eg how do i delete the sample data
without messing up the primary key numbers? and where do i get help on what
the template is actually doing in terms of functions? There's lots of help
for advanced questions, but i just need to know the basics!! If anyone could
give me a hand that would be great. FYI it's the Access Event Management
database template.
thanks