HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Acceptable size for MS Access Database?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sizedatabaseforacceptableaccess

Problem

I have developed an Access 2010 database.

It has three main tables:

HOUSES
id, 
address, 
number_stories, 
garden, 
parking, 
imageAttachments (~1-4 per record),
etc..., 
about 60 fields total

CONTACTS
id, 
houses.id(fk), 
contactType(owner, manager, etc), 
contactEmail, 
contactPhone

VISITS
id, 
Contacts.id(fk),
Houses.id(fk), 
visitDate, 
visitNotes


It also has a bunch of small lookup tables for some of the fields in the houses table.

Right now I have about 100 houses listed and only about 5-10 contacts and visits.

I'm expecting at its peak this database will hold 300-500 houses, with 3-5 contacts and visits for each.

Right now the database size is about 50 MB. I realize I didn't compact/repair it while I was building it or initially populating it which might be one problem. It seems to run very slow. Has this database grown too much? Is this a typical size for a database of this scope?

(I'm on windows 7 with 8 gig RAM so I don't think my own computer is the issue)

Solution

I've had Access databases of 1.5 GB (7 years ago on a machine much weaker than what you've described) run fine - for some queries. It really depends on what you are querying and how it's indexed. Without knowing the details of the queries and reports you're running, I can't say if it's too slow or not (and you don't actually define slow: 10 seconds? 2 seconds? 3 hours?) . I know in the past that Access had a 2GB file-size limit. I don't know if recent versions have changed that.

Context

StackExchange Database Administrators Q#15735, answer score: 2

Revisions (0)

No revisions yet.