Forum Home
Press F1
 
Thread ID: 11555 2001-09-24 23:14:00 Access Bug/Problem Guest (0) Press F1
Post ID Timestamp Content User
19376 2001-09-24 23:14:00 I have a problem in access. Say I have 2 tables with the first field of each one an autonumber. I want these tables to be numbered the same (entry 1 in one table is the same person in entry 1 in the second table). I'm using the database online with asp, and while testing if my scripts work I notice this:

If I add and entry to a table for a test, download the database, delete that entry, upload it again and submit info to the table again; when I download it to view the table, the first autonumber will be 2. I can't figure out a way of setting the first autonumber, or resetting it or something.

I hope someone knows the answer to when you delete all entries in a table where there is an autonumber field, how you get that autonumber back to 0 or whatever.

Thanks a lot,
Ryan.
Guest (0)
1