Replace an autonumber column

[Pettor]

Hello guys,

I have a question about a column that I would like to replace. I have a table with 450.000 records and since there was a lot of data in and out, it turned out to be a very messy numbering in the autonumber column.
I tried to replace it by adding a new one but I received the below message

"The query can't be completed. Either the size of the query result is larger than the maximum size of a database (2GB). or there is not enough temporary storage space on the disk to store the query result."

Is there any way to bypass this message?

Thankis

 

[Pettor]

And guess what, after running the append query, voila....
Same old ****. I can't understand that. even in a blank .db the same story...

 

[Pettor]

Finally it pasted the data even without the undo option. So I guess problem is solved for the time being.

Many Thanks!

 

[Joe4]

Yes, in looking closer, that message isn't really an error message, it is just an informational warning message. It is just telling you that if you proceed, it will not be able to undo the request. But it has no problems going forward with it.