Any ideas, suggestions for slow response time when opening forms?

[tbclbd]

I have an access database which was just converted from Access97 to Access2000. The user is running Windows 2000, and we thought converting the database to 2000 would alleviate the problem of slow response when opening the forms. The program resides locally, while the data resides on the server. When more than one user is in the database, even if you just try to open the table, it takes at least 10 seconds. Some of the forms, which run a query on the table in the on open event, take 10 - 15 seconds to open.

My questions are - If we set relationships on the tables, would that help the response time at all? Are there some settings that we should be aware of which would help the response time?

Thanks for any help.

 

[smedvid]

Perhaps Autocorrect is enabled... see following:

http://dbforums.com/arch/106/2002/7/440023

htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[willir]

tbclbd

Steve has provided one known issue with Access 2000.

Have you run the analysis tools (Talbes and Performance) within Access to check on any bottlenecks and recommendations from the system?

Soemthing else to consider is that Access returns the entire query to the local desktop. The default form retrieves all records for the form. This means whenever you open up a form with a ton of records, the entire record set is transferred. Consider opening the form with out a record set, or apply a filter to retrieve the most recent 100 records, and then allow the user to select the desired record as requried from a combo or list box. Sure, they may want to review the entir record set from time-to-time, but often, only specific records are needed, or new records are added. Reducing the traffic most of the time should help.

Richard