SUGGESTIONS HOW TO SPEED UP AN ACCESS DATABASE PLEASE?
Posted on 2004-11-15
I have created an Access Database that is operating very slowly. It takes about 30 seconds to open the main form. Once I am inside the form, navigating through records is faster; takeing between 5-7 seconds to switch between records.
It is seperated into front-end/back-end, with the back-end being housed on a Novell Server, so data can be shared between 7 users.
All of the systems, with the exception of 1, are fairly good, with speeds of 2.5GHZ or faster, and 512 MB of ram.
The front-end itself is around 200 MB in size, and there are several tables (30 tables) linked to it. Most of the linked tables are around 10-20MB, with 1 being 40, and the others 80, 140, 150, and 200 MB in size. Overall, there is a lot of data in this database.
Although I realize its very hard to diagnose this without having the database in front of you, if any one can offer any suggestions on how I can significantly improve the speed, I'd be overjoyed (especially if they work).
I also want to add that I am really a noob when it comes to Access programming, and although I have been working on this database for a while, I'm sure I don't have even close to the programming knowledge that most of you would consider to be 'decent'. As a result, most of the functionality has been set up 'visually' rather than with code. There is some coding, but it is fairly limited.
Thanks in advance to anyone that can help.
:-) :-) :-)