Lost References

[Nancy]

We have a database that is shared by 5 individuals.
Actually the data is stored in a Sql Server database and
the reports are run from Access. There is code behind
the reports that does specialized formatting. On two of
the computers, the reference to the Microsoft XP Web
Components is "MISSING". I can scroll out to its
location and click on it, but that doesn't fix the
problem. Has anyone encountered this before?

 

[Ken Snell [MVP]]

I have run into this problem when the database was created using SP3 of
ACCESS 2002 but the user is using SP2 of ACCESS 2002. Is everyone using the
same version as the developer? Is everyone using his/her own copy of the
front end?

 

[Nancy]

The database is located on a shared drive. Everyone has
a shortcut to it and runs it from their own Access
program. I checked one of the user's Access version (who
is havaing the problem) and they do have the SP2
version. I developed the original database and have the
SP3 version. I am going to request that their versions
be upgraded to see if that resolves. I suspect that it
will based on your information.

Thanks!

 

[Douglas J. Steele]

I suspect Ken's hit the nail on the head.

It really isn't a good idea to have users share a database on the network:
it increases the likelihood of corruption significantly, and also generates
far more network traffic. Instead, the application should be split into a
front-end (containing the queries, forms, reports, macros and modules),
linked to a back-end (containing just the tables). Only the back-end should
be on the shared drive. Each user should have his/her own copy of the
front-end, preferably on their hard drive.

If you're concerned about ensuring that each user has the correct version of
the front-end, Tony Toews has a free utility to help at
http://www.granite.ab.ca/access/autofe.htm