[AccessD] db As Database

Francisco H Tapia my.lists at verizon.net
Fri Jan 31 10:20:01 CST 2003


IIRC, there is NO ADODB.Database, instead since you're sticking with DAO is
check your refrences and make sure that the DAO one is checked, it is
possible that it is not... next you'll have to explicilty declare all your
DAO/ADO objects, and be careful not to mix the two for example

DIM adoRS as ADODB.Recordset
DIM daoRS as DAO.Recordset


adoRS.Open "Select * From MyTable" ... (etc)
SET daoRS = adoRS

-Francisco
http://rcm.netfirms.com
----- Original Message -----
From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, January 31, 2003 7:02 AM
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
:





More information about the AccessD mailing list