[THIN] Re: Access Problems
- From: Rolph Macphie <rmacphie@xxxxxxxxxxxxxxx>
- To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
- Date: Wed, 11 Sep 2002 12:27:15 +0100
I have made that alteration Thanks
I have not made any system.mdw files.
I wanted SQL in the first place but was told no. I will forward this e-mail
to my FD
Thanks again.
Rolph
-----Original Message-----
From: Mack, Rick [mailto:RMack@xxxxxxxxxxxxxx]
Sent: Wednesday, September 11, 2002 12:06 PM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: Access Problems
Hi,
If database name = rfcbase.mdb, lock file has to be rfcbase.ldb.
Individual or workgroup-shared system.mdw?
However that database is getting big enough that you should be starting to
think about some form of SQL as the back end. That'll avoid all of the
issues you're having.
Regards,
Rick
Ulrich Mack
rmack@xxxxxxxxxxxxxx
Volante Solutions
18 heussler Terrace, Milton 4064
Queensland Australia
tel +61 7 32467704
-----Original Message-----
From: Rolph Macphie [mailto:rmacphie@xxxxxxxxxxxxxxx]
Sent: Wednesday, 11 September 2002 8:31 PM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: Access Problems
I have created this file but it does not appear to have worked, It is
effecting EVERY Access database that we use from time to time.
Rolph
-----Original Message-----
From: Mack, Rick [mailto:RMack@xxxxxxxxxxxxxx]
Sent: Wednesday, September 11, 2002 10:27 AM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: Access Problems
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
**********************************************
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 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 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:
