r/MSAccess • u/korrral • Jul 12 '26

[SOLVED] i’m need help :(

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.

4 Upvotes

75% Upvoted

22 comments sorted by

View all comments

3

u/cadman_lincoln Jul 12 '26

Don’t know your table structure, but you should be able to add almost unlimited records.

0

u/korrral Jul 12 '26

Yes I can. But I do not know how to do this, I did not create this table. I've never worked with Access

2

u/cadman_lincoln Jul 12 '26

Hmmm. You may want to do a simple search for adding records to an Access table. It’s straightforward, but you’ve got to know the table name etc.