[AccessD] db As Database

Hollis,Virginia HollisVJ at pgdp.usec.com
Fri Jan 31 09:03:01 CST 2003


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



More information about the AccessD mailing list