[THIN] Re: Access Problems
- From: "Alexander Danilychev" <teknica@xxxxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Wed, 11 Sep 2002 03:01:33 -0700
Hi,
If your users are looking at similar data they might have a problem due to
Access page locking (records are locked not by rows but by pages).
So, if one user is in the process of modifying a record takes a coffee
break, other users looking at other records in the same page will be locked
out. This problem can be avoided through proper database design as suggested
by Rick.
Note, that this is not the case when data is accessed in read only mode.
So, if this is the case anyway - you have permission problems, such as
READ ONLY, NTFS as well as possible issues with Access own security (i.e.
the lock file).
ALEX
>From: "Mack, Rick" <RMack@xxxxxxxxxxxxxx>
>Reply-To: thin@xxxxxxxxxxxxx
>To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
>Subject: [THIN] Re: Access Problems
>Date: Wed, 11 Sep 2002 19:27:08 +1000
>
>Hi,
>
>Some of this will relate to bad database design, but it's more probably due
>to issues with the database lock file. Try creating the lock file (copy
>nul:
>database.lck), and settings its access permissions to RWX ONLY! for
>everyone
>including admins.
>
>Regards,
>
>Rick
>
>Ulrich Mack
>rmack@xxxxxxxxxxxxxx
>Volante Systems
>18 heussler Terrace, Milton 4064
>Queensland Australia
>tel +61 7 32467704
>
>
>
>-----Original Message-----
>From: Rolph Macphie [mailto:rmacphie@xxxxxxxxxxxxxxx]
>Sent: Wednesday, 11 September 2002 6:57 PM
>To: 'thin@xxxxxxxxxxxxx'
>Subject: [THIN] Access Problems
>
>
>
>I have recently started having major problems with access 2000 SP2. I have
>an Excel Application that uses an access database via ODBC ADO. I have
>about
>6-7 users on this and I am constantly getting "Database Exclusively locked"
>or "Too Many Active Users" error messages even when there is only 1 person
>using it. I am also getting random database locking on
>3 other databases. The only common thing to all this is all running on the
>same Terminal Server 2000 SP3 (was doing it before SP3 hoping it would fix
>it) and all the databases are on the same file server with different
>shares.
>
>
>Any ideas please
>
>
>Rolph Macphie
>
>
>
>**********************************************
>This weeks sponsor 99Point9.com
>99Point9 helps solve your unresolved technical
>server-based questions, issues and incidents. http://www.99point9.com
>***********************************************
>
>For Archives, to Unsubscribe, Subscribe or
>set Digest or Vacation mode use the below link.
>
>http://thethin.net/citrixlist.cfm
>
>
>
>**********************************************************************
>This email may be confidential and/or privileged. Only the intended
>recipient may access or use it. Any dissemination, distribution or
>copying of this email is strictly prohibited. If you are not the
>intended recipient please notify us immediately by return email and
>then erase the email.
>
>We use virus scanning software but exclude all liability for viruses
>or similar in any attachment or message...,..,..,.
>
>
>**********************************************************************
>
>
>
>
>
>**********************************************
>This weeks sponsor 99Point9.com
>99Point9 helps solve your unresolved technical
>server-based questions, issues and incidents.
>http://www.99point9.com
>***********************************************
>
>For Archives, to Unsubscribe, Subscribe or
>set Digest or Vacation mode use the below link.
>
>http://thethin.net/citrixlist.cfm
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
**********************************************
This weeks sponsor 99Point9.com
99Point9 helps solve your unresolved technical
server-based questions, issues and incidents.
http://www.99point9.com
***********************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
Other related posts:
