Access 97 Query

[kickzum]

I have this user who is having a real problem with Access 97. Well, it's not just *one* user, it's a department, but that's kind of irrelevant. Whenever they access the database, everything works smooth and fine (the database is on a mapped network drive so they can all access it). But when they try to execute a query it runs incredibly slow. I'm sure it's not the office installation because multiple users are having the same problem from different machines. The peculiar thing though is that when I manually go into the table of queries and run other queries, it works fine. We are pretty sure there is nothing wrong with the network, although that is a possibility. Any help would be appreciated.

[DVNT1]

To help determine where the problem lies I would copy the database to a local drive and try the same query. If it is very fast, then the problem is not as likely to be with the database design.

If it is still slow then the database or query design may be the problem.

[Lemon]

A co-worker of mine had the same problem. They determined that every instance of access that was accessing the backend DB on the network was allocating a small portion of the network bandwidth and hanging onto it by "pinging" the backend DB. As more people were using the DB at the same time the slower the response became. You may want to try this after work when everyone else has gone home for the day. When you know that you are the only person accessing the DB try the query and time it to see if response time decreases.

[highrock]

I agree with Lemon. I had the same problem when I designed a database for my network. It goes slower depending on how many records it has and if you have embedded or link objects in it too. Access is pretty low end for database management but I like it. I have mine set up for user level security. No name & password no access to database.

[kickzum]

I am going to try that tonight, but I don't think that's it because the users said that day before yesterday it worked smooth as ever. They've been using this same database under the exact same working conditions (read: no new users) for about 5 years now. I tried swapping out the switch their department was patched into, but that didn't seem to help at all. They can access all other components of the network fine, even other databases.

The only thing I have to go on is that the end user might be exaggerating on how long it used to take and how long it takes now. They said it used to take 5-10 seconds, and now sometimes it can last 2-3 minutes. Thanks for the help guys

[VaTech]

I think opening queries in Access locks the tables. I locked up a website once running a query.

[Lemon]

It seems to me I remember that Access can only handle about 5 or 7 concurrent users. How many people are we talking about accessing this DB at once.

Just a dumb question but you have compressed the DB right?