[AccessD] Exclusive connection

Charlotte Foust cfoust at infostatsystems.com
Thu Jul 31 14:38:25 CDT 2003


There is no design mode for a database, only for objects inside a
database.

The idea is to look at the file by establishing a read-only connection
and retrieving the user roster.  Then we want to be able to either lock
it exclusively for things like archiving data or to put a lock on it
that will keep new users for logging so we can get an exclusive lock on
it when the other connections have ended.  

I can put an exclusive lock on the file, but I need a lock that will
still let me use getschema to retrieve the roster.

Charlotte Foust

-----Original Message-----
From: Eric Barro [mailto:ebarro at afsweb.com] 
Sent: Thursday, July 31, 2003 11:20 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Exclusive connection


Charlotte,

How about opening the back end in design mode. That locks out users.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Thursday, July 31, 2003 8:22 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Exclusive connection


Since the file in question is a backend, that would give the wrong
result if a user tried to log in.  The application would prompt them to
locate a datafile, and our help desk would get a bunch of indignant
calls!  I want the app to come back and tell the file file is locked
exclusively so they know they can't use it right now.

Charlotte Foust

-----Original Message-----
From: Bonnie Snider [mailto:BSNIDER at utah.gov] 
Sent: Thursday, July 31, 2003 5:45 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Exclusive connection


How about just rename the file so the users can't find it and do what
you need to do to it and rename it back again?

>>> cfoust at infostatsystems.com 7/30/2003 1:13:42 PM >>>
No, this is a utility tool I'm building, and I need the user to be able
make an ADO connection to a file, get statistics about the file and lock
out other users while he does stuff to it.

Charlotte Foust

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Wednesday, July 30, 2003 11:01 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Exclusive connection 


Charlotte,

Set the database Open property to OpenExclusive.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us 



-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
Sent: Wednesday 2003 Jul 30 13:24
To: AccessD at databaseadvisors.com 
Subject: [AccessD] Exclusive connection 

Does anyone know how to use an ADO connection to lock a database so that
no one else can log into it?  Making the connection is no problem, but
is it possible to make that connection entirely exclusive?

Charlotte Foust
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com

Bonnie Snider, LAN Administrator
DWS North Admin
Phone:   526-9253
Cell:        430-1219
FAX:       526-9744
EMAIL:   bsnider at utah.gov
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list