Solved

Access 97 references missing when files copied from server

Posted on 2007-11-19
6
254 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:jclark33
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:dlan75
ID: 20316112
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
0
 

Author Comment

by:jclark33
ID: 20316744
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'

0
 
LVL 4

Expert Comment

by:MrXmas
ID: 20317537
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
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 12

Expert Comment

by:dlan75
ID: 20318076
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.
0
 

Author Comment

by:jclark33
ID: 20321032
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
0
 
LVL 12

Accepted Solution

by:
dlan75 earned 500 total points
ID: 20321624
Hi,

Check the version of the missing files and of the file that you have to recheck. Those might be different.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Display 2 columns in combobox view 8 30
Random times with 12/24 hour switching 9 28
Importing Excel file into Access 5 29
AvlTree-Node Data type 4 14
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question