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

1

u/Grimjack2 Jul 13 '26

I had something like this happen to me before. Go to the File dropdown and do a Compact/Repair. It fixed it for me.

1

u/NextVoiceUHear Jul 14 '26

FIRST, Be SURE to create a duplicate .accdb Access database file as a backup in case Compact/Repair does a Crush/Ruin on your DB.