[AccessD] Missing library?

Alright...so A97 and A07 WILL play together?
 
I left about a half-hour after my last post, because I had to get back to the office. But, it was on my mind last night, and I swear I must have dreamt about it, because I was pretty convinced, when I came in this morning, that it was an issue between these two versions. I remember reading a bunch of posts, complaining about similar issues. And, personally, we could NOT get my A97 to work, on my PC...my PC was "redone" by our technicians, while I was off w/my knee surgery, and I needed several versions of Access installed. They got 07 and 03 to work together, but for A97 we needed to setup a virtual drive, on my PC.
 
Everything was fine w/this program, before a couple of our younger techs went into this department and swapped out 4 or their 5 PCs. The program still works on the one PC that wasn't touched. So, I had them in my office this morning, and I asked them, along w/their supervisor, if they could "dial these PCs back" and remove 07. I requested that they put A03 and A97 on the PCs instead.
 
I may run over to see these clients this morning. It is only about 1 mile across town, and it'll get me away from my desk. So I can check the order of the references, according to what you've provided. I don't remember exactly all that was loaded, but I was having problems changing the priority of them...it only let me do so much.
 
The top three, if I am reading my notes correctly, were "Visual Basic for Applications" (VBA332.dll), "Microsoft Access 8.0 Object Library" (MSACC8.olb), and "Microsoft DAO 3.51 Object Library" (DAO350.DLL), and it didn't seem that I could alter this order at all. Further down the list was "dao360.dll," and I'm wondering if this is the 3.6 that your talking about...but, I couldn't move this up any higher.
 
This program has been a PITA to me...it was written by an "external" programmer and he didn't follow my rules. Also, he "protected" it and I keep running into road-blocks.
 
I've been doing another job, for the past couple of months...we had a person leave and I inherited their duties, so I've had little time for things like this. So, I don't have a bunch of time to devote to this problem...if I don't fix it by lunch, I'll probably have them blow one away, put it back to scratch, and see if the problem disappears. 
 
John W. Clark
Information Technology Technician
Niagara County
Central Data Processing
         


>>> "William Hindman" <wdhindman at dejpolsystems.com> 7/2/2008 3:38 PM >>>
...you need the Dao 3.6 but ado is installed by default iirc ...and the Dao 
reference must be ahead of the ado ref in the list ...and if the A97 app was 
converted from an earlier version you may need the Dao 3.5 compatibility dll 
as well ...open a code module and then tool/references ...if its grayed out 
you may have to use the ms tool to do a clean uninstall of O2007 first and 
then reinstall A97.

William

--------------------------------------------------
From: "John Clark" <John.Clark at niagaracounty.com>
Sent: Wednesday, July 02, 2008 1:28 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Missing library?

> I am at client PC, looking at an A97 issue. I think I am missing a 
> library. This was a new PC, which we had to install A97 on...came w/A07
>
> I'm not sure what library I need though...DAO? The commands it is erroring 
> on are simple ones..."format" "mid" etc.
>
> I'm not trying to reinstall of A97...any guidance?
>
>
> John W. Clark
> Information Technology Technician
> Niagara County
> Central Data Processing
>
> -- 
> 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