Chris Mackin
chris at denverdb.com
Tue Apr 8 08:56:53 CDT 2003
There is no DAO database object in an .adp so CurrentDB() doesn't work. Some DAO code will work in .adp, but not the full package, you'll probably need to convert your code to ADO. Chris Mackin www.denverdb.com Denver Database Consulting, LLC -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark Hayes Sent: Tuesday, April 08, 2003 7:41 AM To: accessd at databaseadvisors.com Subject: [AccessD] FW: Problem with currentDB in ADP - easy one Hello all... This is probably very simple but I've only just started playing with data projects in XP. I am tring to set a db to currentdb but I keep getting the error that the object variable is not set. I have added a reference to dao 3.6 but I still can't use currentdb... E.g debug.print currentdb.name This fails with error 91 object variable not set Thanks in advance Mark --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com