Size of database

[julz]

I have a database that is 1,881,556 kb in size. After each process we run we
have to compact and repair. If we don't we get the invalid augment message.
Now if we get that message the compact and repair isn't working and I have to
re create the database compacting and repair after importing several tables.
Any suggestions?

 

[Douglas J. Steele]

You need to figure out why your database is that large. You're getting very
close to the 2 Gb limit, which is why you get the error if you don't
compact.

If you're storing binary objects (pictures, Word documents, etc.) in your
database, you should consider storing them externally, and only having a
link to them in your database.

If you're doing constant deletes and additions to your tables, you should
consider using a temporary database.

 

[julz]

Thank you. It's that large because there is just that much data.

 

[Douglas J. Steele]

Probably not what you want to hear, then, but you may be looking at having
to move to SQL Server (or some other server-based DBMS)

 

[Jeff Boyce]

I'm with Doug ... it sounds like you have too much data for an Access
database.

Before you move the furniture, perhaps you'd care to post a description of
the tables/fields you're using now. It may be that you are storing things
that you wouldn't need to, were your database's normalization increased.
Just a thought...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[David W. Fenton]

it sounds like you have too much data for an Access
database.

You mean "for an Jet/ACE database," as Access can handle any amount
of data that the back-end database engine can handle.

 

[Jeff Boyce]

Nice catch.

Yes, what David said ...

Regards

Jeff Boyce
Microsoft Access MVP