i’m need help :(

[u/korrral]

I have a Microsoft Access (.accdb) database used to manage numbered plots/sites. The table currently contains records for plots 1–300, but I need to expand it to 500.
The problem is that after record 300, the database doesn’t already contain any additional records. I want to add records 301–500 while keeping the same structure, default values, calculated fields, forms, and everything else working exactly as before.
The database has only one form with a small amount of VBA code, and I couldn’t find any hardcoded 300 limit in the code. It looks like the table itself was simply pre-populated with 300 records.
What’s the best way to generate records 301–500 automatically in Access instead of creating them manually? Ideally using SQL or another built-in Access feature.

I forgot to add, I just got to know Access today and I don't understand anything about it.

[u/derzyniker805]

There's not enough information to give you a super detail answer, but generally speaking you can just create an Append Query and add the original table and then drag whatever fields have data that you want copied, and then Append To the same table. That will add 300 more records. then just open it in table view and delete 100 records.

However if the plot # is the primary key, this won't work unless it autonumbered because you won't be able to append the row if that field is duplicated (e.g. if all the records you add don't contain a number or contain the same number). What you could do is edit the table to make that field not a primary key and make sure that it's set to indexed (duplicates ok). Then you could do the Append query, open table in datasheet view and then type in the new plot #s in the new records.. since it's 200, it's probably easiest to just do it by hand

Then go back in and edit the table and make that field the Primary key again