Auto increment on existing number column

[lcsgeek]

Is there a way to set the default value of tblTable1.column1 to SELECT MAX(column1)+1 FROM tblTable1?I'm working on an existing table that wasn't setup for autonumber but needs to be going forward. Moreover this is an Access 2003 not sure if that matters. Any assistance would be appreciated. Thanks.

[rpeare]

copy your existing table, but do not copy the data when it prompts you, just the design.

once saved, go into the design of the new table, put in an autonumber field.

Create an append query that will append all the data from your 'old' table into your 'new' table in the order you want it.

Then just run the append query then rename your 'old' table to something else (in case you need to go back to the data) and rename your 'new' table to the 'old' table name.