How to speed up Exclusive form saves?

W

WDSnews

I've split our database and created update scripts so everyone can copy down
the latest front-end. So, since everyone is running their own copy of the
front-end locally and I open the master copy with "Open Exclusive", why do
edits take so long to save? When I save an edited form, or sometimes when I
simply click on a control, I find myself waiting multiple minutes for the
busy timer to quit spinning.

What should I do to decrease the wait time?
 
P

Paul Shapiro

Verify that .mdb files are excepted from anti-malware scanning, both on the
server and the workstation. Verify the latest network drivers on the server
and workstation. If you're opening the master front end over the network,
try making a local copy on your workstation and editing that local copy.
When you're finished, copy the latest version back to the server. Waiting
minutes sounds like something wrong with the networking even if you're
working on an mdb on the server.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top