Link to home
Start Free TrialLog in
Avatar of jclark33
jclark33Flag for United States of America

asked on

Access 97 references missing when files copied from server

I have inherited a giant access97 'wtf' if you will. The process is standard there is central access db that resides on a server share. Different departments have various standalone access 97 db's that link back to the central one on the server. When changes are made I mode my development copies to a server share and each group has a batch file that copies the modified frontend to their local machines. Up till recently this was always successful, but now it seems the references are changing. All user machines have the same access97 installs.

thanks
Avatar of dlan75
dlan75
Flag of France image

Hi,
Still using access 97?
Ok in access after making your modifications, open a module, check that all references are there, recompile your database and then save your modules.
Try then and let me know
Avatar of jclark33

ASKER

Still using access 97?<--not my choice but everything runs of it when i'm not fighting fires i'm trying to migate to mysql backend so i can do something different on the frontside.

as for your solution that didn't help, the libary that comes up missing is the 'microsoft visual basic for apps'

jclark33,

Have you noticed anything about the affected machines?  Are they on a different version of windows?  Can you find the missing library reference on their machine?  If so, could it be listed in more than one place on your machine?

Could you copy the library files to the affected machines so everyone has copies of the "missing" files in the same place?

--Jim Christmas
Hi,
I was just kidding :-)
Ok if this library is missing, then what I would suggest is that on a machine causing the problem, uninstall completely Office 97 then reinstall it making sure you select ALL options and try again.
Jim

thats the odd thing, the files are on the other machines, i just usually have to uncheck the missing one go down the list and recheck it
ASKER CERTIFIED SOLUTION
Avatar of dlan75
dlan75
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial