Forms Open Slow w/multi users

[Susan]

We are using an Access 2000 split database with about 30
linked tables in the backend. The frontend seems to run
extremely slow (about 30 seconds to just open a form)
even when there is only one user in the database.

In the table properties we have the subdatasheet name all
set to [None] instead of [Auto], which has helped in the
past with other databases. Is there some other "setting"
somewhere that needs to be adjusted?

Any ideas would be greatly appreciated!
Thanks for your help!!
Susan

 

[XMan]

Check your queries when openning the first form. If your queries aren't good
then you'll get bad response time IMO.

 

[Susan]

The queries seem to run fast, and pull the correct data.
The form shows correct data when it eventually opens, it
is just really slow.
Thanks!

-----Original Message-----
Check your queries when openning the first form. If your queries aren't good
then you'll get bad response time IMO.

We are using an Access 2000 split database with about 30
linked tables in the backend. The frontend seems to run
extremely slow (about 30 seconds to just open a form)
even when there is only one user in the database.

In the table properties we have the subdatasheet name all
set to [None] instead of [Auto], which has helped in the
past with other databases. Is there some other "setting"
somewhere that needs to be adjusted?

Any ideas would be greatly appreciated!
Thanks for your help!!
Susan

.

 

[Paul Overway]

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

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

The queries seem to run fast, and pull the correct data.
The form shows correct data when it eventually opens, it
is just really slow.
Thanks!

-----Original Message-----
Check your queries when openning the first form. If your queries aren't good
then you'll get bad response time IMO.

We are using an Access 2000 split database with about 30
linked tables in the backend. The frontend seems to run
extremely slow (about 30 seconds to just open a form)
even when there is only one user in the database.

In the table properties we have the subdatasheet name all
set to [None] instead of [Auto], which has helped in the
past with other databases. Is there some other "setting"
somewhere that needs to be adjusted?

Any ideas would be greatly appreciated!
Thanks for your help!!
Susan

.

 

[Susan]

THANK YOU Paul!! I had already fixed the sub datasheet
name and the track name autocorrect, but the LDB locking
seems to have fixed my problems! Thanks again!!

-----Original Message-----
See http://www.granite.ab.ca/access/performancefaq.htm

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

The queries seem to run fast, and pull the correct data.
The form shows correct data when it eventually opens, it
is just really slow.
Thanks!

-----Original Message-----
Check your queries when openning the first form. If

your
queries aren't good

then you'll get bad response time IMO.

We are using an Access 2000 split database with

about
30

linked tables in the backend. The frontend seems to run
extremely slow (about 30 seconds to just open a form)
even when there is only one user in the database.

In the table properties we have the subdatasheet

name
all

set to [None] instead of [Auto], which has helped in the
past with other databases. Is there some other "setting"
somewhere that needs to be adjusted?

Any ideas would be greatly appreciated!
Thanks for your help!!
Susan


.

.