missing or broken reference

[luv2bike2]

I have a db (Access 2003) that several users use, it is located on my file
server. My users use a shortcut to get to it. about a month ago, my network
was upgraded (new servers and domain change). Everything was working fine
before the upgrade. The access databases were moved (copied, I don't know,
it was all done by consultants) over to the new file server. Now users who
have Windows 2000 can open up the database however they can not do anything
because they get a pop up that says:

"Your WO Tracking Database or project contains a missing or broken reference
to the file "msjro.dll" version 2.6
To ensure that your database or project works properly, you must fix this
reference"

Users who have Windows XP have no problem.
On the users computer i deleted the shortcut. On the users computer i went
directly to the file located on the file server and opened up the db from
there and still received the error message on the users computer. This is
happening on Windows 2000 SP4 computers.

If I login as the user into that DB from my computer (which is XP SP3) I do
not get that error message.

What do I need to do to get this working for the users who have windows 2000
SP4?

 

[golfinray]

Go to the Visual Basic editor/tools/references and turn on the references you
need.

 

[Tony Toews [MVP]]

I have a db (Access 2003) that several users use, it is located on my file
server. My users use a shortcut to get to it.

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

"Your WO Tracking Database or project contains a missing or broken reference
to the file "msjro.dll" version 2.6
To ensure that your database or project works properly, you must fix this
reference"

msjro.dll? That appears to be an MDAC dll. Are you using ADO in
your app? Or DAO?

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones (or put the
following code in a module and execute the code), delete from the
references list and Compile and Save All. Keep any necessary
references and ensure they are distributed to the target system.

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

For a very detailed page on reference problems see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

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/