[AccessD] BE Relinker

Reuben,

  Yes that is an option, but if you are using ADO, then anything that's not
prefixed with ADO has a chance of breaking.

  For myself, if I have both checked I always declare everything explicitly.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings
Sent: Tuesday, June 19, 2007 1:39 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] BE Relinker

I think you can actually leave ADO checked, but to do so you must have the
DAO reference listed ahead of the ADO reference.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman
> Sent: Tuesday, June 19, 2007 1:24 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] BE Relinker
>
>
> Patti,
>
>   ADO is the default data lib in A2000 and up and is what is most likely
> giving you problems.
>
>   First, add a reference for DAO.  Then depending on whether you
> want to use
> ADO or not, you can leave it check or uncheck that reference.
>
>   Note that if you leave it checked, you will need to prefix any variable
> dim with either DAO. Or ADO.
>
>   Ie.
>
>    Dim rst as DAO.Recordset
>
>   Then try a compile and make sure you get no errors.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of O'Connor,
> Patricia (OTDA)
> Sent: Tuesday, June 19, 2007 1:14 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] BE Relinker
>
> I have an Access97 front and back end that I am upgrading to 200k first
> then 2003.  I have been using TRIBBLES relinker for over 9 years.
>
> * Is there an upgraded version 2k or 2k3 of TRIBBLE somewhere?
> * If not what needs to be modified to work correctly on 2k and 2k3.
>
> I know I have to add a funtion to enable ENVIRON("USERNAME") to work.
>
> Going through the archives but it takes long time.
>
> FYI - When I tried to get to \\www.databaseadvisors.com it timed out 3
> times.  This happens quite a bit.
>
> Thanks in advance
> Patti
> **************************************************
> * Patricia O'Connor
> * Associate Computer Programmer Analyst
> * OTDA - BDMA
> * (W) mailto:Patricia.O'Connor at otda.state.ny.us
> * (w) mailto:aa1160 at nysemail.state.ny.us
> **************************************************
> --------------------------------------------------------
> This e-mail, including any attachments, may be confidential, privileged or
> otherwise legally protected. It is intended only for the addressee. If you
> received this e-mail in error or from someone who was not
> authorized to send
> it to you, do not disseminate, copy or otherwise use this e-mail or its
> attachments.  Please notify the sender immediately by reply e-mail and
> delete the e-mail from your system.
>
>
> --
> 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