John Clark
John.Clark at niagaracounty.com
Thu Jul 3 09:38:11 CDT 2008
YES! And it drives me flippin' nuts!!! I can't remember which is which,
but one of the directions takes quite a bit longer...I think it is going
back from 07 to 03.
John W. Clark
Information Technology Technician
Niagara County
Central Data Processing
>>> "rockysmolin at bchacc.com" <rockysmolin at bchacc.com> 7/3/2008 10:26 AM
>>>
John:
On the machine where you have 03 and 07 working together do you get
that
"Installing..." message and the 1-2 minute delay while it switches
over
every time you switch from one to the other?
Rocky
Original Message:
-----------------
From: John Clark John.Clark at niagaracounty.com
Date: Thu, 03 Jul 2008 09:59:39 -0400
To: 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
--------------------------------------------------------------------
mail2web.com – Enhanced email for the mobile individual based on
Microsoft®
Exchange - http://link.mail2web.com/Personal/EnhancedEmail
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com