Not enough disk space

[HelsBels]

Hello

I have two tables in access. One is the main table, where all the data is stored. The other table is the import table, which is where the data is loaded & updated (records are deduped, suppressed etc.).

I am trying to load 300,000 records into the import and main tables. I have a primary key set in the main table which is an autonumber field. Once the autonumber is allocated I then need to change the id to a number field. This is because I then obtain the max id number from the main table, and update the import table id's by adding the id number to the max id. So, if the max id in the main table is 30526, the id's in the import table will be 30527 30528 etc.

However, when i try to change the autonumber field to a number, it won't let me save. It says it can't change the data type, there is not enough space or memory.

How can I load this data on - I need the id numbers to follow on concurrently.

Thanks

 

[wizcow2]

HelsBels

I haven't tried to move so many records before so there could be an issue there, but make sure your upload table's number field is a Long Integer as that is the only data type that autonumbers like.

Tom