By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Slow opening query in design mode

P: 3
I have a client who is having problems opening up queries in design mode. When the datafile that the query is looking at is in use by someone else, it takes up to a couple of minutes to open.
I am pretty sure this is not a network problem or a computer speed problem, as they are using gigabit LAN and the database is being stored on a brand new zeon server with 2 gig of RAM, which is not used for anything else!
He thought it might be due to antvirus software scanning the file while opening it, but I've added the databases to the exclusion list and it's still as slow.

Any help would be greatly appreciated!

Thanks
Oct 25 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534

I have a client who is having problems opening up queries in design mode.
Do you mean they're trying to open a query to change it.


When the datafile that the query is looking at is in use by someone else, it takes up to a couple of minutes to open.
By datafile do you mean an access table or an odbc linked table.
Oct 25 '06 #2

P: 3
It is slow just opening it in design mode, without trying to change anything!

- By datafile do you mean an access table or an odbc linked table.

I'm not sure (I'm not a db expert, I just administer the network!) How can I check which it is?
Oct 25 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
In the database design window. Click on the table and click design. If it is a linked table it will tell you as it will warn you that it can't be modified.

You said that other user could be accessing the data. Do you know how the user is doing this. They could be opening the data exclusively which would lock it to other users.

In truth there are a lot of possible solutions to your problem and you may not be able to discover the cause without calling in someone who knows access and if there is a backend database that could be causing the problem. The server could be restricting access to the data.
Oct 25 '06 #4

P: 3
Wouldn't any of these problems simply cause the database to refuse to open at all? The problem here is that if the database is not being viewed, it opens fine in design mode, but if someone else in the office is viewing the database (just looking at data) then it takes much longer to open, although it does eventually open it.
Oct 25 '06 #5

NeoPa
Expert Mod 15k+
P: 31,470
Does it always take the same amount of time when it is delayed, or is it possible that it is waiting for a particular situation on a remote PC to resolve before allowing it to move on?
For instance, another user may have a record (or whole table even) locked and the 'designer' may only get access when they have moved on.
Oct 25 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.