References

[Leslie Isaacs]

Hello All

I have a split Access2K mdb, with a backend on a server and a frontend on
each of 5 PCs. I routinely work on a 'master' version of the frontend, which
also lives on the server and which is copied to each PC when it is booted up
in the morning. The frontend includes a 3rd party add-in application, which
requires some .ini files to be in place on the local workstation, and some
references to be set. Everything works fine, except that some of the PCs
don't seem to retain these references: immediately after each boot-up these
references are either unticked, or they are ticked but annotated as MISSING.
Then they have to be re-selected, and all if fine again ... until the next
boot-up.

This behaviour seems not to be consistent, either across all the PCs or even
for a given PC - or at least I have not been able to identify any rule that
will predict when the references will be retained and when they will not.

Anyone any ideas?

Hope someone can help.

Many thanks
Leslie Isaacs

 

[Douglas J. Steele]

See whether what I've got at
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html helps you.
There are also a number of references on this topic in my December, 2003
"Access Answers" column in Pinnacle Publication's "Smart Access", although I
don't know how many of the references cited are still around. (You can
download the column and a sample database that includes hyperlinks to all of
the references for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html )

A good resource for trying to automate your process is what MichKa has at
http://www.trigeminal.com/usenet/usenet026.asp

 

[Tony Toews [MVP]]

The frontend includes a 3rd party add-in application, which
requires some .ini files to be in place on the local workstation, and some
references to be set. Everything works fine, except that some of the PCs
don't seem to retain these references: immediately after each boot-up these
references are either unticked, or they are ticked but annotated as MISSING.
Then they have to be re-selected, and all if fine again ... until the next
boot-up.

Run the following code and we'll give you some suggestions. Also
specifically which references are you having problems with?

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 Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Leslie Isaacs]

Tony

Many thanks for your offer. It's Sunday here now so I'm not in the office,
but will be tomorrow and will run your code and get back to you then.

Cheers
Les

 

[Leslie Isaacs]

Douglas

Many thanks for your reply.

I have to say that reading everything at the references you gave did serve
to show me how little I know! I'm afraid a lot of it was beyond me - and I
couldn't even get past step 1 of MichKa's guide! I did get from it the need
to ensure that all the ini files are the same version, and in the same
location, on each PC and on the development machine - but I have already
done this.

I will try again to follow your article, and Michka's, and I also now have
some code from Tony Toews that might help. I'll report backj here tomorrow.

Thanks again
Les

 

[Leslie Isaacs]

Tony

Just to let you know that 'something came up' today - so I didn't get to the
office today! Will do tomorrow, and will report back.

Thanks for bearing with me.
Les

 

[PayeDoc]

Hello Tony

I have now run your code, following which the immediate window shows:

VBA - 4.0 & ref.FullPath
Access - 9.0 & ref.FullPath
DAO - 5.0 & ref.FullPath
jmail - 4.0 & ref.FullPath
ADODB - 2.5 & ref.FullPath
SHDocVw - 1.1 & ref.FullPath
MSForms - 2.0 & ref.FullPath
stdole - 2.0 & ref.FullPath
MhcalndrLib - 7.0 & ref.FullPath
VBIDE - 5.3 & ref.FullPath
InetTransferLib - 0.0 & ref.FullPath
MSACAL - 7.0 & ref.FullPath
e45Object - 1.0 & ref.FullPath
ePAYEDoc - 11.0 & ref.FullPath
eSubmissionObject - 1.0 & ref.FullPath
Excel - 1.2 & ref.FullPath


The problem references are:
e45Object - 1.0 & ref.FullPath
ePAYEDoc - 11.0 & ref.FullPath
eSubmissionObject - 1.0 & ref.FullPath

Where do I go from here?

Many thanks for your help.
Les