jclark33
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
thanks
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'
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
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.
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.
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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