William Hindman
wdhindman at dejpolsystems.com
Thu Jul 3 09:23:05 CDT 2008
...they will play if the installation order is right and you have the patience of job ...I've moved to having each in a separate virtual pc install instead ...in case you've not noticed, patience is not one of my virtues ...with ms giving away free copies of xp on a vhd, it just doesn't make sense to me to try and mix them all on the same platform any longer. ...btw, iirc the presence of dao 3.51 means you have unconverted A2/A95 code in the mdb and it will not play further up the line ...if you intend to keep this app alive, you need to do a full conversion in A97 and update all that old code before upgrading further ...imnsho of course. William -------------------------------------------------- From: "John Clark" <John.Clark at niagaracounty.com> Sent: Thursday, July 03, 2008 9:59 AM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com