are deleted unless you delete the key, save the table and recreate the key.
In one of the recent posts John suggested using Integer / Long Integer and
then using VBA to do the record incrementing. I personally would go for that
to avoid the problem of AutoNumber.
Regards
Liveson
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of isz98
Sent: Tuesday, 25 April, 2006 5:54 AM
To: [email protected]
Subject: [ms_access] Set Autonumber back to #1
Dear all,
I set one of the database field as an autonumber.After I delete the
records, and add new new record, the autonumber doesnt start at 1. Can
anybody give me advice on this?
Thanks
Isz
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
