Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Access table size limit

Locked

Access 97 has a table size limit of 1 gig. I’m told that Access 2000 has a 2 gig limit.

Even 2 gigs is too small for my purposes. Is there any solution, other than giving up and going back to old FoxPro?

Topic

Access table size limit

In reply to Access table size limit

You are right NO solution for Access
I would go FORWARD to SQL server 7 instead of backwards

If you are handling such large amounts of data you should be looking at an “Industrial”
strength data engine

Access table size limit

In reply to Access table size limit

The question was auto-closed by TechRepublic

Access table size limit

In reply to Access table size limit

I agree with the previous answer that going backwards is not the best choice. I would recommend Progress RDBMS. Tests have found that a data set in Progress that is 1.5 MB while the exact same data set in SQL Server is over 3 MB and using Oracle it weighs in at over 9 MB!
The only restrictions would be operating system induced. Progress Version 9 is a VERY powerful engine and should do all you need.

Access table size limit

In reply to Access table size limit

The question was auto-closed by TechRepublic

Access table size limit

In reply to Access table size limit

This question was auto closed due to inactivity

[Author]

Replies