MS Access Multiuser - Multi User Queries taking forever....

Author

Multi User Queries taking forever....

Roman B.

2006-01-18, 3:24 am

We have 10 users using access XP 2002, accessing an access database with
about 300,000 records. currently it is taking about 6-8 minutes per lookup on
the database which resides on a windows 2003 server with 2 gigs of Ram. Is
this normal or is there something I can do to speed the lookups? My systems
are running windows XP SP2 with at least 512 megs ram with most close to a
gig a ram locally.

Van T. Dinh

2006-01-18, 7:24 am

(multiple replies in Queries newsgroup)

Please do not multipost the same question in different newsgroups. Please
see:

http://www.mvps.org/access/netquette.htm

--
HTH
Van T. Dinh
MVP (Access)

"Roman B." <RomanB@discussions.microsoft.com> wrote in message
news:4C29B22E-4890-4532-A434- 40E228884532@microso
ft.com...
> We have 10 users using access XP 2002, accessing an access database with
> about 300,000 records. currently it is taking about 6-8 minutes per lookup
> on
> the database which resides on a windows 2003 server with 2 gigs of Ram. Is
> this normal or is there something I can do to speed the lookups? My
> systems
> are running windows XP SP2 with at least 512 megs ram with most close to a
> gig a ram locally.

Roman B.

2006-01-18, 9:24 am

Hey Van,

Thanks for the heads up, however I've posted in microsft newsgroups before
only to be told that I my question should be posted in another newsgroup.

Thanks I'll check out your link.

"Van T. Dinh" wrote:

> (multiple replies in Queries newsgroup)
>
> Please do not multipost the same question in different newsgroups. Please
> see:
>
> http://www.mvps.org/access/netquette.htm
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Roman B." <RomanB@discussions.microsoft.com> wrote in message
> news:4C29B22E-4890-4532-A434- 40E228884532@microso
ft.com...
>
>
>

Rick Brandt

2006-01-18, 9:24 am

Roman B. wrote:
> Hey Van,
>
> Thanks for the heads up, however I've posted in microsft newsgroups
> before only to be told that I my question should be posted in another
> newsgroup.

In that case you should crosspost rather than multi-post (to a reasonably
short list of groups). See link for explanation.

http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Van T. Dinh

2006-01-18, 9:24 am

If you read a few Microsoft Access newsgroups, you will notice that regular
respondents read and reply to posts in a large number of Access newsgroups.
Provide that your question is related to Access, I think you find, in
general, the same group of respondents who will reply to your question
regardless of the Access newsgroup you posted to.

OTOH, you can use cross-posting to make your question appearing in a number
of groups (max 3 newsgroups only, please) as Rick advised and you can check
all answers regardless of which newsgroup you want to look at.

--
HTH
Van T. Dinh
MVP (Access)

"Roman B." <RomanB@discussions.microsoft.com> wrote in message
news:20561431-6758-4B4C-8DC2- 80D0C361875B@microso
ft.com...
> Hey Van,
>
> Thanks for the heads up, however I've posted in microsft newsgroups before
> only to be told that I my question should be posted in another newsgroup.
>
> Thanks I'll check out your link.
>
>

Roman B.

2006-01-18, 1:24 pm

Thanks ... Next Time I'll use the crossposting feature.

thanks again
roman

"Van T. Dinh" wrote:

> If you read a few Microsoft Access newsgroups, you will notice that regular
> respondents read and reply to posts in a large number of Access newsgroups.
> Provide that your question is related to Access, I think you find, in
> general, the same group of respondents who will reply to your question
> regardless of the Access newsgroup you posted to.
>
> OTOH, you can use cross-posting to make your question appearing in a number
> of groups (max 3 newsgroups only, please) as Rick advised and you can check
> all answers regardless of which newsgroup you want to look at.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Roman B." <RomanB@discussions.microsoft.com> wrote in message
> news:20561431-6758-4B4C-8DC2- 80D0C361875B@microso
ft.com...
>
>
>

Sponsored Links