Limit on number of Records?

mstng07

Registered User.
Local time
Yesterday, 19:25
Joined
Feb 5, 2008
Messages
18
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!
 

Users who are viewing this thread

Back
Top Bottom