Access 2007 Encrypted BackEnd Slow Only With New ACCDB -
I encrypt back-end ACCDB on the Win / 2003 network.
Front end on user workstation Link tables and make copies all work perfectly.
I open a new blank database and link to the same back-end. It is very slow, but only clicking on any table from a new front-end launches forever.
This seems to be just a problem, if other users have a front-end app.
I have tried to change the name of empty DB for the match which works; that does not matter.
It seems that if you open a front end in a back-end ACCDB, then another front-end (such as the empty ACCDB with the new link), the same back-end of serious latency Experiences happen.
Any thoughts on what might happen?
The solution is to maintain a constant connection.
If you want to open a table which is too small (probably just a record) and keep it open then everything responds quickly.
You can also open a form which has a small table in its record set, as long as the connection is kept open / continuous.
Comments
Post a Comment