Question Access not responding momentarily after query

[BBrian]

I've inherited a network running Windows 7 with a 2008 server (only server here), each client uses Access 2010 Runtime and an in-house database application I'm unfamiliar with.

When users try to open a record, Access immediately changes to Not Responding with the blue circle mouse-pointer. A few seconds pass and "Running Query" appears in the status-bar, everything pauses for a few more seconds, the progress-bar fills and then the record opens that the user requires.

The behaviour is the same on computers that have Windows freshly installed and have been around for a while. Some users have redirected profiles and some always sit at the same computer. Non-domain computers are the same. In each case, the acccdr files are under c:\programdata and I've given users full permissions during my troubleshooting.

It seems to me it's pausing while waiting for a network response. The server's not under any strain -- it has plenty of free RAM and networking and CPU usage never go too high.

I'm not really sure where to go with this. It's not quite an Access issue, but hopefully someone here has encountered it and can shed some light on it.

 

[Toff]

I recently went thru this with my users. The database will never be as fast as they want.

Go through your tables and update your indexes. This helped me a ton but I still get a little pausing now and then. If any tables have thousands upon thousands of records, make sure you have filters on all your queries and such so your not looking at or updating something in the entire table.

Also in Database Tools, use the Analyze Performance one. Its useful.

 

[boblarson]

As I read the original question, it would appear that you do not have the ability to go into the database in design view. Is that correct? If that is the case then there isn't anything you can do. It most likely is, as Toff suggests, some fixes that need to occur within the design of the database.

 

[BBrian]

I wrote a long message here, but figured out a bit more when reading up on DoCmd.OpenForm. I'm looking at the indexes again now.