template basics

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top