Hi, Todd.
How can I get it to start at 297?
If you need the numbers in this column to be sequential, then you shouldn't
be using an AutoNumber, because they aren't guaranteed to be sequential,
even when they're set to increment by 1. You should use a custom function
to return a sequential number.
That said, assuming that you have 296 records in this table and no numbers
in this column above 297, first make a backup of the database file, turn off
"Track name AutoCorrect," then delete any relationships with this table's
related tables. Rename your table, then make a copy of the structure (no
data) and name this copy the same as the original table. Append the data
from the original table into the new, empty table. Try:
INSERT INTO tblEmptyTable
SELECT *
FROM tblOldTable
ORDER BY ID;
.. . . where tblEmptyTable is the copy of the table that you made which has
been renamed as the original table's name, tblOldTable is the original table
full of records, and ID is the AutoNumber column. When done, reestablish
the relationships with any related tables on the new table. When you've
verified that everything is correct, delete the old table and compact.
When you add a new record, the AutoNumber will be 297.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
