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

Query slow for one user, not others

P: n/a
Using A2K. I have a form with a combo box that runs a query and
returns a list of patients. 3 users are sharing this database and the
query runs fine for 2 of the users but not the 3rd. The query takes
2-3 minutes to execute for the 3rd.

Thinking this is more of a pc issue and not a database issue, I
inquired about their pc's and was assured that all 3 pc's are about 1
year old and are identical. They are all using Windows XP Business
edition.

Anyone else had a similar problem? I am stuck as to what to do next.
Any help or advice is appreciated.
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
My first guess would be a bad network connection. It might work fine for
most things, but when you start copying a lot of data, it starts to break
down. Try copying a few large files (50MB or larger) to and from this
computer and see what happens compared to the other computers. Also, in case
there is a problem with the front end database file on this computer, try
copying one of the known "good" copies form the other computers over to this
computer.

--
Wayne Morgan
Microsoft Access MVP
"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da************************@posting.google.com ...
Using A2K. I have a form with a combo box that runs a query and
returns a list of patients. 3 users are sharing this database and the
query runs fine for 2 of the users but not the 3rd. The query takes
2-3 minutes to execute for the 3rd.

Thinking this is more of a pc issue and not a database issue, I
inquired about their pc's and was assured that all 3 pc's are about 1
year old and are identical. They are all using Windows XP Business
edition.

Anyone else had a similar problem? I am stuck as to what to do next.
Any help or advice is appreciated.

Nov 13 '05 #2

P: n/a
Is it possible that the slow user has his/her front end buried deeper in the
directory structure than the others?
I've found it can make quite a difference having both front and back ends
close to the root of the directory.

HTH
- Turtle

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da************************@posting.google.com ...
Using A2K. I have a form with a combo box that runs a query and
returns a list of patients. 3 users are sharing this database and the
query runs fine for 2 of the users but not the 3rd. The query takes
2-3 minutes to execute for the 3rd.

Thinking this is more of a pc issue and not a database issue, I
inquired about their pc's and was assured that all 3 pc's are about 1
year old and are identical. They are all using Windows XP Business
edition.

Anyone else had a similar problem? I am stuck as to what to do next.
Any help or advice is appreciated.

Nov 13 '05 #3

P: n/a
Also, Does the computer in question have ant-virus software running that is
also scanning files/the backend on the server?
--
Reggie

www.smittysinet.com
----------
"MacDermott" <ma********@nospam.com> wrote in message
news:cE******************@newsread3.news.atl.earth link.net...
Is it possible that the slow user has his/her front end buried deeper in the directory structure than the others?
I've found it can make quite a difference having both front and back ends
close to the root of the directory.

HTH
- Turtle

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da************************@posting.google.com ...
Using A2K. I have a form with a combo box that runs a query and
returns a list of patients. 3 users are sharing this database and the
query runs fine for 2 of the users but not the 3rd. The query takes
2-3 minutes to execute for the 3rd.

Thinking this is more of a pc issue and not a database issue, I
inquired about their pc's and was assured that all 3 pc's are about 1
year old and are identical. They are all using Windows XP Business
edition.

Anyone else had a similar problem? I am stuck as to what to do next.
Any help or advice is appreciated.


Nov 13 '05 #4

P: n/a
Thanks for your replies. Tech support is taking a look at the network
config for this user. I'll suggest the anti-virus issue.

This isn't a fe/be situation. The entire database is on the network.

"Reggie" <no**********@smittysinet.com> wrote in message news:<yb********************@comcast.com>...
Also, Does the computer in question have ant-virus software running that is
also scanning files/the backend on the server?
--
Reggie

www.smittysinet.com
----------
"MacDermott" <ma********@nospam.com> wrote in message
news:cE******************@newsread3.news.atl.earth link.net...
Is it possible that the slow user has his/her front end buried deeper in

the
directory structure than the others?
I've found it can make quite a difference having both front and back ends
close to the root of the directory.

HTH
- Turtle

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da************************@posting.google.com ...
Using A2K. I have a form with a combo box that runs a query and
returns a list of patients. 3 users are sharing this database and the
query runs fine for 2 of the users but not the 3rd. The query takes
2-3 minutes to execute for the 3rd.

Thinking this is more of a pc issue and not a database issue, I
inquired about their pc's and was assured that all 3 pc's are about 1
year old and are identical. They are all using Windows XP Business
edition.

Anyone else had a similar problem? I am stuck as to what to do next.
Any help or advice is appreciated.


Nov 13 '05 #5

P: n/a
Then may I suggest that you split the database with data in the backend and
queries, forms, reports, and temporary items in the front end. If everyone
is using the same single file on the backend, you are asking for corruption.

--
Wayne Morgan
MS Access MVP
"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
Thanks for your replies. Tech support is taking a look at the network
config for this user. I'll suggest the anti-virus issue.

This isn't a fe/be situation. The entire database is on the network.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.