Keith Williamson
kwilliam at ashlandnet.com
Tue Feb 18 11:47:01 CST 2003
I didn't change the default...so it should still be DAO. But I'll check when I get home, and see if my references are wrong. Thanks, Keith E. Williamson Ashland Equipment, Inc phone # (410) 273-1856 fax # (410) 273-1859 -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Wortz, Charles Sent: Tuesday, February 18, 2003 12:31 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Declaring Database Keith, Which data access method are you using? DAO or ADO? In A97 and earlier, DAO is the default data access method. In A2K and later, ADO is the default. You need to explicitly type your database as either DAO or ADODB if you have both referenced. 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 (SELECT * FROM users WHERE clue > 0) -----Original Message----- From: Keith Williamson [mailto:kwilliam at ashlandnet.com] Sent: Tuesday 2003 Feb 18 11:13 To: accessd at databaseadvisors.com Subject: [AccessD] Declaring Database Can anyone shed some light on why my Access 97 would be having a problem with a "Dim dbs as database" declaration? I was using the Switchboard Manager utility to setup menus on my application. In the process of this, the utility wizard created code which included the above declaration. However, the application keeps giving me an error on that line, saying the variable isn't defined. Isn't that what the declaration is doing???...defining the variable?? Can't imagine what the problem is. Anyone with any ideas? I've used the wizard a number of times to setup menus. Never had this problem before. Thanks in advance, Keith E. Williamson Ashland Equipment, Inc phone # (410) 273-1856 fax # (410) 273-1859 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com