Connecting Tech Pros Worldwide Forums | Help | Site Map

Performance drops after first lock

Rick Heijster
Guest
 
Posts: n/a
#1: Nov 13 '05
Hi All!

I have an issue with a MS Access database. My application is split into two
parts: the Front End, with all the forms (located on the local computers of
the users) and the Back End database, located on the server (Windows 2000
Advanced Server). As soon as any user puts a lock on the database, the
performance for *all* users drop dramatically.

Does anyone know what the cause of this may be?

Thanks in advance for all your help.

Rick Heijster





Allen Browne
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Performance drops after first lock


This is probably due to a combination of factors. See Tony Toews'
Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm

Not sure if Tony has this one in there yet:
http://support.microsoft.com/?id=834350

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rick Heijster" <rick@rick-online.nl> wrote in message
news:eo0Vc.112170$i7.10297@amsnews05.chello.com...[color=blue]
> Hi All!
>
> I have an issue with a MS Access database. My application is split into
> two
> parts: the Front End, with all the forms (located on the local computers
> of
> the users) and the Back End database, located on the server (Windows 2000
> Advanced Server). As soon as any user puts a lock on the database, the
> performance for *all* users drop dramatically.
>
> Does anyone know what the cause of this may be?
>
> Thanks in advance for all your help.
>
> Rick Heijster[/color]


Rick Heijster
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Performance drops after first lock


These two files do sound to address my problem. Thanks! I will let you guys
know if it solved my issue.

Rick

"Allen Browne" <AllenBrowne@SeeSig.Invalid> schreef in bericht
news:41249ae2$0$22817$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
> This is probably due to a combination of factors. See Tony Toews'
> Performance FAQ at:
> http://www.granite.ab.ca/access/performancefaq.htm
>
> Not sure if Tony has this one in there yet:
> http://support.microsoft.com/?id=834350
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Rick Heijster" <rick@rick-online.nl> wrote in message
> news:eo0Vc.112170$i7.10297@amsnews05.chello.com...[color=green]
> > Hi All!
> >
> > I have an issue with a MS Access database. My application is split into
> > two
> > parts: the Front End, with all the forms (located on the local computers
> > of
> > the users) and the Back End database, located on the server (Windows[/color][/color]
2000[color=blue][color=green]
> > Advanced Server). As soon as any user puts a lock on the database, the
> > performance for *all* users drop dramatically.
> >
> > Does anyone know what the cause of this may be?
> >
> > Thanks in advance for all your help.
> >
> > Rick Heijster[/color]
>
>[/color]


Tony Toews
Guest
 
Posts: n/a
#4: Nov 13 '05

re: Performance drops after first lock


"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote:
[color=blue]
>Not sure if Tony has this one in there yet:
> http://support.microsoft.com/?id=834350[/color]

I do now. Thanks for the reminder. And this fix is included in the massive Win XP
SP2.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Closed Thread