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