Reference Problem

[nz_avatar]

I have an access 2000 format mdb on a network share that four users update.
We are running a mixture of Office 2003 SBE, Office 2003 Professional. One
of the users who is running Off 2003 SBE has installed Access 2007
(standalone) to run the shared app.
In refererences there is a reference to msoutl.olb. In the other 3 users
machines the location is C:\Program Files\Microsoft
Office\OFFICE11\msoutl.olb.
The problem is with the access 2007 machine which shows the location as
\\othercomputername\c$\Program Files\Microsoft Office\OFFICE11\msoutl.olb.
This seems to be why acc 2007 hangs and crashes all the time.
Does anyone know how to fix this please?
Cheers

 

[Douglas J. Steele]

Your application needs to be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). Only the back-end should be on the network share:
each user should have his/her own copy of the front-end, ideally on his/her
hard drive.

Once you've done that, you'll be able to fix the reference for the Access
2007 user, and it won't impact the other users.

 

[nz_avatar]

Yes, you are absolutely correct Douglas.
This will soon be a legacy application as I have been writing a new one in
VS2005.

I did a detect and repair in Outlook 2003 and that appears to have fixed the
error with referencing msoutl.olb on another machine.
Thankyou for the assist.
Cheers