Charlotte Foust
cfoust at infostatsystems.com
Thu Oct 16 15:15:52 CDT 2003
You can't set a database object in ADO anyhow, because there *is* no database object in ADO. CurrentDB should work in Access 2k and later regardless because it isn't DAO, it's a function built into the application, but it depends on what you're trying to do with it. The ADO equivalent is CurrentProject, which quite handily has a Path property and a FullName property that will give you either the current database's path only or its full name and path. However, it doesn't return a database object, merely an object. Charlotte Foust -----Original Message----- From: Elam, Debbie [mailto:DElam at jenkens.com] Sent: Thursday, October 16, 2003 11:36 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] ADO CurrentDB() Is there an equivalent of CurrentDB() in ADO? Explicitly defining the place where a database resides is much easier to break. CurrentDB() worked so well in DAO it is hard to believe that an equivalent does not exist. Debbie - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com