[AccessD] db As Database

Here is another method just set your Access 2000 connection object to a 
DAO connection
works from an ADP or MDB  database and can point to an SQL or MDB databasae.
This is a bit of a kludge but should get you up and running without a 
lot of conversion at the expense
of  speed.

see http://www.trigeminal.com/code/ado_to_dao.bas

Arthur Fuller wrote:

>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
>>    
>>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>