[Tyler5690]

I work at a small business, where we keep a lot of our records in a Microsoft Access database with quite a bit of custom coded forms running on top. We generally have one to three users accessing it at the same time. Our database size is already past 800 MB, and we are starting to have crashes. I would like to either migrate to another database, or optimize our existing setup, so that we can run smoothly without crashes. My only worry is safely moving the forms and reports. As I'm not much of a programmer, the less coding required, the better.

Does anybody have any ideas what to do?

Thanks!

TT

[Advertisements]

this is probably not what you're going to want to hear...but...

if this is all business critical data (i.e. if you lose it you will cause MAJOR hardship to the business) then it MIGHT be in your best interest to contact a specialist that can give you a hand with this....

this is not to say that there's no chance of such a specialist being here and being able to suggest something or help you out...but if it's REALLY critical data...then it's in your best interest to have someone who's experienced PHYSICALLY available to do the transfer (if only so you have someone else's neck to wring besides your own if something goes wrong)

[dsenette]

this is probably not what you're going to want to hear...but...

if this is all business critical data (i.e. if you lose it you will cause MAJOR hardship to the business) then it MIGHT be in your best interest to contact a specialist that can give you a hand with this....

this is not to say that there's no chance of such a specialist being here and being able to suggest something or help you out...but if it's REALLY critical data...then it's in your best interest to have someone who's experienced PHYSICALLY available to do the transfer (if only so you have someone else's neck to wring besides your own if something goes wrong)

[Jonesey]

It's my understanding that Access is capable of dealing with databases of up to about 2 million records.

I've never seen one that big myself, but we run some very large ones here with no crashes.

how many records are you talking about?

Is it possible for you to reduce the size simply by archiving old data?

Also, are the pc's your users are using up to the task?

Access has a fairly modest memory footprint, but when intercating with forms etc might be stressing the CPU