Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Outgrowing Access

  • Please log in to reply




  • Member
  • PipPipPip
  • 135 posts
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?


  • 0




    Je suis Napoléon!

  • Community Leader
  • 26,047 posts
  • MVP
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)
  • 0




  • Member
  • PipPipPip
  • 335 posts
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
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP