Hi all.

I have an odd problem. I have 4 pc's on a small network, all Win XP
SP2. I'm using Access XP (2002 I think). Program works fine on 3 PCs
and won't compile (or run successfully) on 4th. Lots of code in Forms
and Modules. I've tried decompile with no joy. I've tried re-
registering a couple of DLLs (DAO360, for example) but no effect at
all. I don't believe it's a corruption problem in the Access file
since it works fine on the other 3 PCs - and at home too. Next stage
is to re-install the Office package I suppose but I thought I'd throw
this to the group to see if anyone else has come across a similar
problem (and solved it!). Thanks.

JB

jbguernsey wrote:

What happens if you create a new mdb on that computer? Can you create a
table, a query, form, a simple function that runs from a module?

Can you create a new mdb and import all objects into it?

Do the references on that computer look correct?

On Mar 25, 4:52*pm, Salad <o... (AT) vinegar (DOT) com> wrote:
That's what odd about it. I have another Access program on the
offending PC that runs fine - compiles OK and everything! It seems to
be just this one program on this one PC.

I'm thinking of trying SavetoText but don't really believe it will
work - decompiling certainly didn't ...

Thanks

JB

jbguernsey wrote:
I don't know if reinstalling Access will help your problem if you can
compile another program on that computer.

I'd create a new mdb and import the objects. See if that does anything
in the new mdb.

On Mar 25, 8:06*pm, Salad <o... (AT) vinegar (DOT) com> wrote:
Yeah, tried that. Didn't help. My thinking is along the lines of
corrupted library somewhere. Might be an Office lib or maybe even a
Windows lib. If it's Office a re-install mught help. If it's Windows
I dread to think of the effort that's going to be reqd. - machine is
heavily used for lots of different purposes!

Thanks for your help.

JB

jbguernsey wrote:
I really don't know. What happens if you import the tables, queries,
and maybe 3 or 4 forms?

On Mar 26, 1:43*pm, Salad <o... (AT) vinegar (DOT) com> wrote:
Well, I haven't had a chance to try too much yet. One problem is that
lots of code routines call other routines/refer to open forms etc. so
a partial import falls over when compiling cos so much is missing!

Another thought I had was that maybe something installed on the PC
which is not on the others is causing some kind of clash.

The real b*ll-breaker, however, is the fact that the same prog
compiles and works fine everywhere else. Seems to preclude a problem
in the prog and to point to something odd about the PC.

I can't get to it now until next week and I'll have another attack at
it then. Nil carborandum illigitimi!

Thanks again.

JB

It never rains ... my website and email was hosted by Lycos - which
ceased operations about a week ago with absolutely no warning! Nice
of them to think about their clients and inform us ... not!

jbguernsey wrote:

I figured you could pull in a couple of forms that didn't make calls to
other forms/reports/modules and simply see if it compiles the new mdb.

I'd get your reference lists on the ones that work and the one that
doesn't and do a compare between the two. See if there is a conflict
between the two or perhaps a change in the order. Like I said before, I
really don't know. Sometimes one throws mud at the walls and hopes
something sticks.

jbguernsey <jeff (AT) angelsystems (DOT) co.uk> wrote:

Do you get any messages?

I see you've tried importing into another MDB so that should clean out your
references. Or did you add some back in? Nevertheless run the following code and
let us know what's in there.


Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & " - " &
ref.FullPath
Next ref

End Sub

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

On Mar 26, 11:05*pm, "Tony Toews [MVP]" <tto... (AT) telusplanet (DOT) net>
wrote:
Well, I got it working. I uninstalled Office and re-installed it. It
had a number of updates prior to the uninstall. After re-install with
no updates it works!

The PC in question was the only one with the updates to the Office
package so the culprit seems to be there. I don't have the time (or
patience) to mess around trying to discover which update broke it.
I'm satisfied that it now works.

Thanks to everyone who gave advice.

JB