Speed up a slow database

[EvilCabal]

Hey, I have been working on a access database/interface for about a year. The database is now quite big and I've began to experience some major speed problems. Most computer here are win98 SE, some are win2000. I've tried splitting the database into a front-end for the interface and a back-end for the tables, I've tried compacting it, optimizing it. Nothing will do. I even get some "out of memory" errors and this is really starting to ANNOY me . Is there anything I could do to improve the overall performances? Should I plan on changing the database format? Thank you for the help!

 

[hermanlaksko]

Here is what I think you should do.

1. spilt up your database, as you allready did - but from your text it looks like you put it back together again.

2. create a new empty database container (an mdb file) and import your front end to this new database.

For some odd reason makes these errores if one has too many saves to them (and some times the odd crash here and there :-D).
when I experince the above I give my app this treatment and ..... it workes like a charm ...... again ;-)

Herman

 

[nat1967]

Hi Evil,

You didnt mention what version of Access you are using. A2K has some known performance issues especially if you are using Front/Back end systems with a shared server.

Check out this link. Tony has done a great job listing and addressing the issues. I followed his information and performance on my database improved tremendously. (Users are very happy now!)

http://www.granite.ab.ca/access/a2kslow.htm

Nathan
Senior Test Lead