[AccessD] db As Database

Virginia,

Access 2000 and later uses Unicode, so the size roughly doubles from A97.  There is no such thing as ADODB.Database, so don't even try.  You can't just swap object  models to convert DAO code to ADO, the syntax is quite different and so are most of the objects.  Use DAO.Database and set a reference to the DAO Object library in the VBE.

Charlotte Foust

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] 
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