Custom Toolbar Slow the Database

[Guest]

Database front end, held on my 'c' drive has a toolbar which I created. The
database backend is held on the server. The database runs fine when only I
am using it but when another user is given their own copy of the forms on
their 'c' drive and we both use it at the same time the system slow to the
extent that it takes over a minute to just open a form which is not based on
anything. If I remove the toolbar and go back to using forms as menus the
system works fine. Any suggestions

 

[Albert D.Kallal]

If I remove the toolbar and go back to using forms as menus the
system works fine

I don't think the tool bar is the issue at all here.

if you are going to use ms-access in multi-user mode, you need to force the
connection to the back end to STAY OPEN.

So, in your startup code, simply open a table in the back end (any table).
YOU MUST KEEP THIS table open. Now, all your delays will go away.

you can also just test this by creating a small form that is attached to a
back end table, and then minimize it. This will also fix the slow problem.

you should also be distributing a mde to your users, not a mdb.

For the above persistent connection trick, and to fix other performance
problems, check the following check list...it is a real gem;

http://www.granite.ab.ca/access/performancefaq.htm