Is there a limit on the number of records you can have in an access database? I've got one with 8500 records and it's been a PITA! I have a webpage on our intranet so users can go and enter their information to it, and they get a nasty error whenever they try to enter information. I'm trying to figure out why and i was just wondering... i know it's not the webpage because when i connect it to my test database it works fine? so i dunno :confused:

any help is greatly appreciated!!

AFAIK there is *no* limit on the number of records in an Access db. There is however an overall size limit of 1GB or 2GB depending on the version you are using. You should be able to ask Access Help (not VBA Help) about "Specifications" and get this information. Not in Access 2007 of course.

To Access, 8500 records is chump change. We have posters who report literally MILLIONS of records, usually spread out over multiple files to get the size limits up.

What "nasty" error is being reported? When you ask for help here, provide us enough specifics to have a shot at figuring out your problem.

Well since it wasn't the webpage, i knew it had to be the database. I fixed it though, i did the backup of the database and it works, so i need to go in and set it to compact and repair automatically. I didn't initally set up this database or i would have set it to do so already ;) it's just my job now to maintain it oh well.

Thanks for your help though!

Here's a link to a ghudson thread where it watches the size of the db and does a C&R when needed.
http://www.access-programmers.co.uk/forums/showthread.php?t=114688