Slow performance while designing

[David Ewer]

I have a simple access database set-up as follows:

I have a database called PM which contains approximately
10 tables and nothing else. I have another database
called PM2003 which links to all the tables on PM but has
not tables of its own. It also has a number of queries,
forms and reports.

Both these files are .MDB files and reside on a shared
folder on my SBS2003 server. From the PM2003.MDB file I
have created a .MDE file which resides in the same
directory as the .MDB files. All users have a shortcut on
their workstation (running Windows XP Pro and Office 2003
Pro).

I have noticed that when I try to modify the design of
any form or report in PM2003.MDB whilst someone is
accessing the database (but not my report or form) then
the design process grinds to a halt with several second
delay between me doing something and the action being
performed. If nodoby is accessing the database it is very
quick.

Is this normal? If No how can I find out what is causing
this?

Thanks

David

 

['69 Camaro]

Hi, David.

Is this normal?

Let's just say that this behavior is "expected." One would also expect
either occasional or frequent database corruption with the configuration
you've described, too.

Saving your design changes is slow because so many other users are using the
same locking database file, PM2003.LDB.

For optimal database performance, maintenance, and least likelihood of
database corruption, Access database developers split the database (as
you've already done), place a copy of the front end on each user's
workstation, and make design changes to a development copy on the
developer's workstation. All locking database files for the front end will
be on separate computers, thereby eliminating the interference that your
database configuration is currently contending with.

When those database design changes are ready for the next release, the
development front end is copied to the network server for distribution to
the users. One can automate this distribution with Tony Toews's autofe
utility. Please see the following Web page for more information:

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

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

Thanks for the advise. Funnily enough I do also have a
problem with occasional database corruption So hopefully
you have resolved this for me as well.

Kind regards

David

 

['69 Camaro]

You're welcome. Hope it helps eliminate that occasional corruption, too.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)