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)