[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