Shared DB performance

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

Database Information:
BE Location: I:\ (at the root, as an .mdb file, size about
9MB)
FE Location: Users desktop, size about 21MB as an .mde
file.
Persistent connection to BE with a form always loaded (but
invisible)
Sub Datasheet set to [None]
Track name AutoCorret set to Off
Shortened the name of the BE
Logos are linked, not embedded.

When a user has the db opened and another user tries to
open it, it takes a good 30 seconds before (s)he can view
it. Any other suggestions? Thanks, Antonio
 
Antonio said:
Persistent connection to BE with a form always loaded (but
invisible)
Click to expand...

But is that form bound to a table in the backend?

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
 
Antonio said:
Yes, Tony. It's the main Customers Info form
Click to expand...

Darn. That should be all you need.

No disrespect intended but are you sure it is pulling in some records?
There's nothing wierd on the record source or filter or something like
that?

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
 
Back
Top