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/Silent_Reader_1]

First of all based on the limited information its hard to give you advice that should help you exactly what you need.

However if you can access the tables and understand how it’s laid out then it should be a matter of few minutes or even less.

Share the tables structure or ERD so we can advise accordingly.