Community archive

Ask something
Discussion Locked

MS Access - database size

0 helpful
2 replies

by mariana.enescu

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a series of reporting applications that interrogate a database (that contains only data). The problem is : one of my tables contains now more than 3.000.000 records and MS Access failed !! Did anyone meet the maximum size of a table? What I can do in this situation, without to migrate to something else? Please help!

2 replies

by spikeymike

Esteemed Colleague:

This is exactly why you should never use Access. Here is my litmus test for using it: Is the application going to have more than two users? Is the application going to contain critical data? Is the database going to get big? If the answer is NO to all 3, then by all means, use Access. Otherwise, stay away! It is pure junk.

Go and migrate your data to Sybase SQL Anywhere - it is a small-footprint RDBMS that doesn't cost a fortune. It will handle your 3 million row table just fine.

For performance reasons, you may want to consider using a RAID array.

Regards,

-Mike

by been there

If you can bring up the database without opening the tables try this go to the tools menu click on Database Utilities, click on repair database,and then compact database. Hope this works.

This discussion is closed to new replies.