Solved

Access 97 references missing when files copied from server

Posted on 2007-11-19
6
238 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
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 …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now