Front end workstations converted from Access 2000 to 2002

[Tim]

I have a frontend backend for a user who runs Windows
2000. The backend is on a server. The frontend is on a
workstation that formerly had Windows 2000 with Office
2000. After the user installed Office XP (without
notifying me, of course) bringing up the frontend gets two
errors:
1. Your database application ... contains a missing or
broken reference to the file 'dirwalk2.ocx'.
2. [ditto, except:] 'dpedit.dll'

Then when I try to relink to the backend database, I get
the error:
'You do not have the necessary permissions to use the [bla-
bla-bla_be.mdb] object. Have your system
administrator...establish the appropriate permissions...'

I am not using a workgroup security file, just the
standard security with database password. The LAN folder
containing the backend database is fully accessible from
the workstation.

Any ideas?

 

[Cheryl Fischer]

Tim,

Perhaps I can help with part of your question. DirWalk2.OCX and DPEdit.DLL
are probably add-ins (usually used with earlier versions of Visual Basic).
They are not built-ins of MS Access. It is possible that when your user
installed Office XP overwriting Office 2000, that these two files were
"blown away". You can try doing a Search (Start button|Search) for either
of these two files. If the search locates them, make a note of their full
path. Then open the database (holding down the shift key to bypass any
startup code). Press F11 to open a VBA code window; then, from the VBA
menu, click Tools|References and find these two, which are probably marked
as missing. Use the Browse button to navigate to the locations you noted
and reset the references.

If you cannot find these files anywhere on the hard drive of your user, you
may have to go to a backup or perhaps a network folder containing these
components. If your database was created by a contractor or other outside
source, perhaps they might be able to supply these to you.

hth,