Forms Open Slow w/multi users

  • Thread starter Thread starter Susan
  • Start date Start date
S

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
 
Check your queries when openning the first form. If your queries aren't good
then you'll get bad response time IMO.
 
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
Click to expand...


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

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


Susan said:
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
Click to expand...


.
Click to expand...
Click to expand...
 
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
Click to expand...
your
queries aren't good
then you'll get bad response time IMO.

We are using an Access 2000 split database with
Click to expand...
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
Click to expand...
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


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top