slow responce from network

[Joel]

I've split my data base with the tables on the network
and forms on local stations. I'm running Novell small
business 6.5 with a cisco switch.

Everytime we load the main form it sits for 30 to 45
seconds before opening. Before I split the database it
worked fine.

Any suggestions why now it takes so long to load?

 

[Tony Toews]

I've split my data base with the tables on the network
and forms on local stations. I'm running Novell small
business 6.5 with a cisco switch.

Everytime we load the main form it sits for 30 to 45
seconds before opening. Before I split the database it
worked fine.

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Also see the Novell Netware page at the Microsoft Access Corruption
FAQ at http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm