does access has a limit

M

mpsamuels01

I currently have an access db that is right now at over 2gb. I am very
intersted in knowing do it have a maximum size before you have to
change the platform. The reason y I ask this question besides the fact
that it is 2gb every time i try to create a simple table, create a new
query, run an existing query, import a table I get an error saying
invalid argument. I did some research and that usuaally applied to
people using a source from outside of access and that is not the case
in this situation. Is there also some good practices to reduce the size
of the database itself.
 
R

Rick Brandt

I currently have an access db that is right now at over 2gb. I am very
intersted in knowing do it have a maximum size before you have to
change the platform. The reason y I ask this question besides the fact
that it is 2gb every time i try to create a simple table, create a new
query, run an existing query, import a table I get an error saying
invalid argument. I did some research and that usuaally applied to
people using a source from outside of access and that is not the case
in this situation. Is there also some good practices to reduce the
size of the database itself.
Click to expand...

Welcome to the limit! 2GB is it.

Are you sure some of it is not bloat? Have you compacted it recently? Do
you do a lot of importing and then deleting? That will bloat a file fast.
If the size is from real data then it is definitely time for you to move to
a different platform.
 
V

Van T. Dinh

2 GB for A2000 and later, 1 GB for A97.

2 GB is a very big database if you don't store binary files such as graphics
in your database. Graphics tend to bloat the database a lot. For example,
a client (Order Entry system for a manufacturing company with approx. 70
employees) has been in use for 6 years and only up to 36 MB.

Do regular Compacting and check the size of the database after compacting.
 
M

mpsamuels01

Ok Rick you are correct I have been doing a lot of importing and
deleting I was able to compact the database and took a db litterally
that was reading at 2,125,036 to 232,000.

Van see alot of my tables deal with large numbers for instance my
biggest table has 460,000 rows with about 28 columns and then another
one with 226,000 and I have to run a lot of queries using those two
tables.

But if my database eventually reaches the 2gb maximum do you guys offer
a better resource.

Or even suggest ways to minimize the space on the document as far as
variable types
 
Top