Bonnie Snider
BSNIDER at utah.gov
Thu Jul 31 10:40:35 CDT 2003
Well, at least I tried. Better to take a risk and fall than never to take a risk at all. :-) >>> cfoust at infostatsystems.com 7/31/2003 9:21:39 AM >>> 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 Bonnie Snider, LAN Administrator DWS North Admin Phone: 526-9253 Cell: 430-1219 FAX: 526-9744 EMAIL: bsnider at utah.gov