[AccessD] db As Database

Since I only work in SQL this is no longer an issue for me, but what about
creating a static function that returns said value? Why create a public when
there's no need? Create a static instead and call it whenever you need it;
no need for a public. I can't think of a reason why you might want to do it,
but the same technique could easily work in ADP. Grab the current connection
and store it in a static var in a static func. Then retrieve it whenever you
need it.

A.

----- Original Message -----
From: <davesharpe2 at cox.net>
To: <accessd at databaseadvisors.com>
Sent: Friday, January 31, 2003 2:29 PM
Subject: Re: [AccessD] db As Database


> Virginia
>
> A guess- I've done no research but "public" may
> be a "reserved word". You might try renaming to
> "mypublic" of something before attempting
> conversion.
>
> Dave
>
> >
> > From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>
> > Date: 2003/01/31 Fri AM 08:27:59 EST
> > 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
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com