BE Database

[JenK]

I have a backend/ front end database. I like it but I find that it is slow on
loading forms from the switchboard, I have tried the compact/ repair button
but it doesn't seem to speed it up a whole lot. Does anyone have any other
suggestions on how to speed my database up?

 

[Jeff Boyce]

There are a few possibilities...

First, let's rule out the possibility that you have a single copy of the
front-end residing on your LAN. A standard front-end/back-end design puts a
copy of the front-end on every user's PC.

Then, a common reason for slow-loading forms is because the form is trying
to load ALL the related records. Do your forms provide a way for users to
select a single record to work with, or are ALL the records connected to the
form, and the user sifts through/filters/etc.?

One more thing ... we "enjoy" a massive slow-down of our forms after the
network gurus installed a new update to the network antivirus software.
Does this apply?

You can find other ideas about slow-over-the-network performance at Tony T's
site:

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

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John J.]

The following has solved similar problems I had in the past:
http://www.granite.ab.ca/access/performanceldblocking.htm

John

 

[JenK]

My database is password protected, can I still have a copy of the front end
on every computer that requires a password?
If so How do I do it. I can't seem to get it to work unless everyone is
opening the shortcut that was created when I secured the database.

 

[Jeff Boyce]

I can't tell from your description whether you "secured the database" using
Access security, or via some code-based security you created yourself.

If the former, try posting in the access.security newsgroup ... they're
likely to have more experience with this.

If the latter, please explain more how you implemented it...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JenK]

I did use Access security so I will go in there and see if anyone can help.
Thank-you all for your help.
I placed an un-secured version on my desktop and it runs really fast so I
believe that the problem was that everyone was running it off the server.