Bonnie Snider
BSNIDER at utah.gov
Thu Jul 31 08:45:21 CDT 2003
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