John Clark
John.Clark at niagaracounty.com
Wed Jul 9 08:11:47 CDT 2008
I am still having issues w/the program I asked for help on last week. My schedule hasn't allowed me to work on this an more than I have, but I do have a our head technician working on it w/me...actually he has pretty much taken over most of the leg work, and I am consulting w/him.
To rehash and update the problem, we gave new computers to our Risk Management department, and since the move, there Case Management System, which was written in A97 is not working. It errors out..."compile error"...on the "format" and "mid" statements (although just "format" has been coming up lately).
These new PCs were loaded w/Office 2007, before being placed on the desktop, and A97 was loaded on-site. So, I figured it had to be an issue w/A97 playing well w/A07...I had a problem myself, earlier this year, and I had to setup a virtual machine, on my computer, so that I could use my A97 for our older programs.
Now, yesterday, I tried running this PC, from my virtual PC, and I get the compile errors there too. There is one untouched PC, at the Risk dept, so I stopped by there yesterday, while our for lunch, to see how this was setup...what references it had. It had three...in order..."Visual Basic Applications", "Microsoft Access 8.0 object library", and "Microsoft DAO 3.51 object library." Mine had these three, in the same order, w/an extra one "Office 8.0" between the 2nd and 3rd ones. I deleted this extra to no avail.
We took one of the new PCs and wiped it away, and put it back to out-of-the-box condition. We reloaded A97, and still got the error...not really a surprise, considering I got it too, although I really did think this was going to fix it, when we started out on this endeavor. The tech is now dealing w/an "our of memory" error...it is a new PC w/2 GB of memory, so he has some updates to do...although I don't understand how the other techs didn't run into this problem.
For the time being, we have returned the worker's old PC to her, and it is all working.
I am having a told-you-so opportunity, because, this department...and my boss...went behind my back and hired an external programmer to create this program, and now we're having issues, while none of mine, old or new, have any major problems. This guy used workgroups, which is something I do not use...I manage everything through Novell rights...there is no need, in our scenario, for different rights...you either have access to the program or you don't. I do not work w/workgroups, so I don't know what problems I'll have updating this, if I need to...and it is looking like I may need to.
Maybe this is something I should try. Will I have problems updating an A97 program, using workgroups, to a higher version...probably 2003?
Or, how can I tell what references I need...if this is truly a reference problem?
John W. Clark
Information Technology Technician
Niagara County
Central Data Processing
>>> "John Clark" <John.Clark at niagaracounty.com> 7/3/2008 9:59 AM >>>
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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com