MS Access Size Limitation

[saomot2000]

Hi,
Is there a work-around on the 1.99GB size limitation of the MS Access database?
If there is, what is it?
Thank you!

 

[maxmangion]

you can use Linked tables from other databases.

 

[saomot2000]

Doesn't that solution cause a lot of dependencies?

 

[maxmangion]

but it is a possible solution for your question. To be fair 1.99 GB is quite a large capacity for an Access Database ... what kind of db do you have so that you need more than this limit ?

 

[saomot2000]

I actually imported data from an Oracle database to do some manipulation on the data. The size is an issue since the data files I imported are in the range of 1.3GB.

 

[Pat Hartman]

I would do the manipulation in Oracle. Link to the tables and run your queries. Then return only the selected records. That should minimize your data problem.