Hi,
I wonder can anyone tell me what happens to records that Access tries to insert once it reaches its maximum size of 2GB. I've tried inserting records through an asp.net application but i get no errors and no records are going in.
Thanks.

They go into the bit bucket :D OK, it's an old joke but I'm sure a few of you will get it.

They are lost. If there is no room in the database where would you think they should go?

Part of your problem is that asp and access don't communicate errors to each other quite as well as they communicate errors internal to themselves. I'm sure that Access is sending an error but ASP process is not seeing it.

As to what to do, time to clean up your DB

1. Kick off all users.
2. Backup the DB
3. Repair DB (having failed record inserts will probably leave behind cruddy records)
4. Compress DB
5. See how much space you retrieve.

6.a. If it is a lot, go back on line
6.b. If it doesn't give you back very much, immediately contemplate ways to archive your oldest data into another DB used for archival storage.
6.c. If ALL of your data is still valid - i.e. NOTHING can be archived 'cause you need it all - time to change backend to something that ain't access.