Inefficient forms

[Guest]

To All

I developed a database program (using Access 2000) that is divided into a 2 parts, the back-end database component contains the main tables of the database, the front-end component hold the forms, reports, modules, etc. and includes links to these back-end tables. In the front-end database component I created several forms that employ the use of tab controls with subforms inbedded in the pages of the tab controls. Everything works fine except when these forms are being opened in a multiuser environment or if more than one user has opened a copy of the front end component of the database; these forms then can become very slow to open. With only a single user, the forms open fine but can really slow down when more than one user is logged in. My questions are: 1) Is this problem caused by my extensive use of subforms or is there likely another factor or combination of factors causing this problem? 2) What can I do to resolve this matter? and 3) Do later versions of Access, Access 2002 or Access 2004, perform any better? Your input would be greatly appreciated

Thank you

Art

 

[Joan Wild]

To All:

I developed a database program (using Access 2000) that is divided
into a 2 parts, the back-end database component contains the main
tables of the database, the front-end component hold the forms,
reports, modules, etc. and includes links to these back-end tables.

Everything works fine except when these forms are
being opened in a multiuser environment or if more than one user has
opened a copy of the front end component of the database; these forms
then can become very slow to open.

You should give each user a copy of the frontend on their workstation. If
you don't, you'll likely have corruption problems.

 

[Albert D. Kallal]

To All:

I developed a database program (using Access 2000) that is divided into a

2 parts, the back-end database component contains the main tables of the
database, the front-end component hold the forms, reports, modules, etc. and
includes links to these back-end tables.

That seems like a good setup..have a split system...good!

In the front-end database component I created several forms that employ the

use of tab controls with subforms inbedded in the pages of the tab controls.
Everything works fine except when these forms are being opened in a
multiuser environment

If the form performance ok with 1 user, then additional users should work
ok. I would do a few things:

Make sure each pc gets a copy of the front end (place the FE on EACH pc).

That front end should be a mde.

Keep a connection or table to the back end database opened (that means to
force a persistent connection by opening a table to the back end..and
keeping it open..you can use any table for this).

Turn off track-name autocorrect.

do the above...and you should be just fine. For a further list of things to
check look at:

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

You could also consider NOT loading the sub-form until the actual tab is
clicked on..as that can a large amount of load time also..but as you
say..with one user across the network...it performance ok now.