Low speed shared database

[Afsaneh]

Dear All,
I have placed my access database(Back end [just the tables] and front end
[other components]) on a server and every user can run it by a shortcut on
the desktop .one more thing about my database is that I have secured it using
encrypt/decrypt database wisard . the problem is that, it takes a long time
for forms to get loaded. I don't know why, it is so slow that first the
database seems to be in a not responding mode. I appreciate any help.

 

[Jerry Whittle]

It could be something as simple as the virus checkers on the computers. Try
disabling the virus checker and see if it works faster.

Another performance problem can be fixed with a persistant connection.
Create a small table in the BE and link it to a form in the FE. Make this
form open when the database does, then go invisible. Keeping the form open
can make connections to the BE work faster.