Discussion Locked

MS Access Application - MultiUsers

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have split an Access DB into Front/Backend. Front is .mde and Back is .mdb
Backend resides on NT Server with Linked Tables in Frontends on 5 Workstations. First User gets access to Backend tables in 5 seconds, other users vary from 25 to 60 seconds. Any suggestions for increased speed?

1 reply

by edd_polaski

we have had the same issues. my suggestion is to use a faster switching device between the servers and then convert all of your macros into VB. We have done this and our speed has increased.

This discussion is closed to new replies.