Access Auto Number Help

[jsmmao]

Hi,
I have a quick question. I am working on Windows XP with Microsoft Office 2003. The database I am working on has over 300,000 lines and what I am trying to do is make another field with numbers so that I can identify each line when running a query. When I try to set an Autonumber field it says "file sharing lock exceeded. Increase MaxLocksPerFile registry entry". Does anyone have any ideas as to how to fix this issue?



Thanks in advance

[jsmmao]

Or...is there anyway to auto fill a new column to go from 1-300,000

thanks

[RuralGuy]

Create a New Table with the extra AutoNumber field then append the old table to it.

[jsmmao]

How exactly do you do that once you have the two tables. Thanks alot for your help. Any ideas are appreciated.

[jsmmao]

through a query? I wanted to keep it in a table

[RuralGuy]

Can you use a wizard to make an Append query?

[RuralGuy]

An Action Query such as an Append query will modify an existing table.

[jsmmao]

I tried running it through the wizard and I cant get it to work. Im not sure what to use to establish a relationship between in both of the tables. There really isnt a constant..

Thanks again for your help and sorry if Im not understanding (somewhat a beginner on access)

[RuralGuy]

You create a SELECT query of the New table then in design mode of the query RightClick and select QueryType and then Append Query.

[jsmmao]

I still cant get it to work. It will not append once in the Select query. I opened the new table up (with the autonumber) in the new query. Then I try to append it to my other table with all of the information. It tells me I can do it.

[RuralGuy]

My post #9 should have said create a SELECT query of the *old* table. Then switch it to an Append query and it will ask you to what table.

[jsmmao]

Ok, that works. Thanks for your help

[RuralGuy]

You're welcome. Glad we could help.