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

Performance drops after first lock

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <ri**@rick-online.nl> wrote in message
news:eo*******************@amsnews05.chello.com...
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

Nov 13 '05 #2

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

Rick

"Allen Browne" <Al*********@SeeSig.Invalid> schreef in bericht
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
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" <ri**@rick-online.nl> wrote in message
news:eo*******************@amsnews05.chello.com...
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


Nov 13 '05 #3

P: n/a
"Allen Browne" <Al*********@SeeSig.Invalid> wrote:
Not sure if Tony has this one in there yet:
http://support.microsoft.com/?id=834350


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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.