Discussion Locked

Network Performance Degradation

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I suffer significant degradation in network performance when accessing a *.mdb database across a windows ME network using OCBC drivers and MDAC. The machine has a K2 400 processor on a Soyo motherboard and 3com network card. Is there a known conflict with MDAC and AMD processors? Thanks

7 replies

by dcadmin

Check the size of the database, it may be time to compact the database, try that first.

by tynemouth

are you using an *.mde to access this DBase? You can also compact the mde as it also grows in size as you use it. In Access hold down the "shift" key and then open the mde, go to db utilities and compact the mde. If you are using an mde, after compacting, it will act as normal and try to attach to the DB again.

by rpfarrell

Data base is only 30mb and is compacted and repaired on a weekly basis. Thanks. If I reverse "client" "server" with data base on a Celeron 400 machine there is no dergradation of speed!

by 4u21der

If you are running this 30 megs DB from ACCESS then its time to move it to a SQL server.

This is the 20/20 rule from MS.

20 megs or greater OR 20 or more users. Needs to be on a SQL server.

Access cannot handle that size of a DB easily. So compact or move it to a SQL DB.

Resoure:Microsoft Articles
=========================
Schedule Compacting of DB.
Article ID: Q209979
=========================
=========================
Optimize Access 2000 DB
Article ID: Q209091
=========================

Hope this helps.

Good Luck!

This discussion is closed to new replies.