Speed issues

lryckman · November 29th, 2005, 03:17 PM

Hello everyone!
I am having some speed issues with my databases. I was wondering if anyone had any suggestions.
Here is what I am running:
Windows 2000 professional
Office XP
2GB RAM
3.40GHz
Profile = 100MB (Can't get it any smaller)
Running across a Microsoft Network.

Runs slow on opening the database, opening forms, saving forms and code, performance analyzer, and documenter.
By slow, I mean it takes literally 5 minutes to open or save a form at times. It took one hour to run the documenter on a 3MB database. It took about 25 minutes on the performance analyzer.

I keep the code compiled and the database compacted as often as possible.

Any ideas would be greatly appreciated.

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

echovue · November 29th, 2005, 03:24 PM

Hi Laura,

I have had this problem before as well. It sounds like you are running the database from a server. It may be worth copying it to your local workstation and seeing if that makes a difference. If it does, then the problem isn't the database, it is either the network or the server itself.

Somethings that I have found that have affected mine...

- User is on a 10 Mb connection vs a 100 Mb connection
- A process is running on the server that slows it down (Our network guys are nice enough to run a full virus scan once a month that kills us for 2 or 3 days)
- Spyware or other malicious programs.

You have probably already tried this as well, but running a compact and repair on the Database can make a huge difference as well (Tools -> Database Utilities -> Compact and Repair)

Hope that helps a little,

Mike

Mike
EchoVue.com

mmcdonal · November 30th, 2005, 09:21 AM

If you are running the database from the server, you will need to split it. Keep the back end (just tables) on the server, and then copy the front end (queries, forms, reports, macros, modules) to your desktop and run it from there.

Do NOT copy a shortcut to the front end and keep the front end on the server! This is a mistake many users make.

To be clear:

Server = Database Back End File (.mdb)

Workstation = Database Front End File (.mdb - not shortcut)

All workstations that use this set up will need to have the same drive mappings as the machine you split the database on.

Do you need help on splitting the database?

HTH

mmcdonal