[AccessD] BE Relinker

I agree 100%.  I was just pointing it out.

I know this because I had a lot of DAO code, but when I needed to add
something in ADO I simply made that reference last and then used ADODB as a
prefix.

Now I prefix everything.

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 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
>