[AccessD] BE Relinker

For myself, I declare everything explicitly regardless of references.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Tuesday, June 19, 2007 3:07 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com