Jim Dettman
jimdettman at verizon.net
Wed Jul 9 08:36:48 CDT 2008
John,
On one of the problem PC's I would:
1. Login with admin rights.
2. Check for multiple copies of DAO351.DLL. Make sure there is only one.
3. Re-register DAO from the command prompt:
regsvr32.exe C:\winnt\system32\DAO351.dll
Note: Change the path as appropriate.
4. Open A97, create a new MDB. Open a module and go to tools/references.
Make sure you have the primary three and make sure none are listed as
missing or broken. If they are, you'll need to fix them. If none are,
check any unchecked reference (note which). Close the MDB and Access.
Re-open and uncheck the reference you just checked. Now do a compile. You
should get no errors.
5. Open the debug window and type:
Debug.? MID("TEST THIS",4,2)
It should work.
6. Now open your app that your having a problem with and try a compile. If
it works, stop. If not, go through the check/uncheck process in step 4. If
you still have compile errors after that, then it is most likely corruption
in the MDB.
7. Take the MDB your created in step 4 and import all the objects into it
from the app. Then try a compile.
HTH,
Jim.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Wednesday, July 09, 2008 9:12 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Missing library? REVISITED
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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com