Is it possible to increase Access 2000 Database to more than 2G?

[Guest]

I have created a database and my company has been using it for 2 years.
Currently it is at 1.99 GB, and I am experiencing errors when accessing the
database on the network. Is it possible to increase the memory of this
database? I'm open to any other suggestions as well.

Thank you

 

[Ron Hinds]

Have you tried Compacting the database? That's something you should be doing
on a regular basis - at least once a week. Also, there is no reason why you
can't have multiple database files for your backend - each one would then be
allowed up to 2GB. Figure out which tables are growing the most and separate
them between the two databases evenly.

 

[Douglas J Steele]

Sorry, that's a hard limit.

I'm assuming you've compacted the database to be able to recover unused
space. If so, and it's still at that size, is there anyway you can move some
of the data to another database?

 

[Roger Carlson]

I'm assuming you have already split the database into a FE (front-end) and
BE (back-end). If you haven't, that should be your first step.

After that, the only way is to put the tables into multiple back-end
databases and link them into your Front-end. You lose Referential Integrity
that way, but it makes the size of the database virtually unlimited
(theorically).

The other option is to move to a different database engine like MySQL, MSDE,
or SQL Server.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Albert D.Kallal]

Normally, you database will have MILLIONS of records if you reach the 2 GB
limit.

Do you have millions of records?

Also, what is the size of the database AFTER you do a compact and repair?

 

[Douglas J Steele]

Don't forget, Albert, that it could have tens of pictures in it, rather than
millions of records, to add up to 2 Gb!