Doug Murphy
doug at murphyscreativity.com
Fri Jan 31 10:18:00 CST 2003
I am sure you checked but make sure DAO is referenced. You should probably unreferenced ADO. Doug -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Hollis,Virginia Sent: Friday, January 31, 2003 7:02 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] db As Database Why does doing that make the size of the database so large? I tried Paul's Public db as DAO.DataBase or Public db as ADODB.DataBase & still received the same error. When I did Jim's suggestion, the database grew, compacting didn't help. Virginia -----Original Message----- From: Jim Dettman [mailto:jimdettman at earthlink.net] Sent: Wednesday, January 29, 2003 8:19 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] db As Database Either declare it explicitly as Paul said, or uncheck the ADO lib in the references and check the DAO one. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of paul.hartland at fsmail.net Sent: Friday, January 31, 2003 8:38 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] db As Database I think you have to change it to Public db as DAO.DataBase or Public db as ADODB.DataBase Paul From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com> Date: Fri 31/Jan/2003 13:27 GMT To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com> Subject: [AccessD] db As Database This is probably an old question since most have already converted to A2k... When converting from 97 to 2000, I receive the error, "User defined type - not defined" on, Public db As Database. What can I change this to so it works in 2000? Virginia _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________________________________ __ Freeserve AnyTime - Go online whenever you want for just £6.99 a month for your first 3 months, that's HALF PRICE! And then it's just £13.99 a month after that. For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890 _______________________________________________ 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com