One PC not able to calculate formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I posted a question (One PC not able to calculate formulas ect.) a few
days ago and John Spencer answered it. I marked the post a answered so I
figured it wouldnt be checked again and I had to repost the question. Anyway,
John gave me an answer that I had missing or messed up referances and that I
needed to fix them on the machine I was having trouble on. John, would I open
a blank database or the .mdb file everyone is using on the network and just
uncheck the each referance close the database then re-open and check the ones
needed again? Sorry for the repost....
 
Are you using ONE database on a server that everyone is accessing? If so,
you need to split the database into two parts and give each user a separate
front end that contains all the forms, reports, queries, etc and is linked
to the backend which contains the data. If you don't know how to split the
database there is a database utility (Tools: Utilities: Database Splitter)
in Access.

Make a backup copy (if this is the only database you have and it is not
split)
On the computer where the problem exists, open the database with the problem
in design mode.
Switch to the VBA window (Control + G or open a code module)
Compile the code (Debug: Compile...)
If you get no errors then select Tools: References

Then check the reference libraries on that computer. If one is marked
missing, uncheck it (note the name). Close the references window. Compile
the code and if you get no errors, then you probably weren't using the
reference anyway, so you can allow everyone to use a copy with that
reference library unchecked. If the reference is needed then you are going
to have to get the reference library installed on the PC with the problem.


This was probably my response to your original posting. (By the way you
could use Google Groups to search for that posting.)

To do its job, Access makes use of various external program and object
libraries. If you move a database from one machine to another, these
references may be "broken".

When this happens, you need to take steps to let Access repair the
reference(s) ON THE COMPUTER WHERE THE FAILURE IS OCCURING.

Here are MVP Doug Steele's instructions for how to do it:

*** Quote ***

Any time functions that previously worked suddenly don't, the first thing to
suspect is a references problem.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Just so you know: the problem will occur even if the library that contains
the specific function that's failing doesn't have a problem.

**** End Quote ****

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
John, thanks I figured you would see this post! Your advice is very helpfull.
One question though. How do I "Compile the code (Debug: Compile...)" im new
to this so could you explain please? Im not going to split the database
because first I never have done that and second basicly we enter data from
one PC and my two boses look at it once a day from thier PC's and dont enter
data into it. Thanks!!!!
 
John, thanks I figured you would see this post! Your advice is very helpfull.
One question though. How do I "Compile the code (Debug: Compile...)" im new
to this so could you explain please? Im not going to split the database
because first I never have done that and second basicly we enter data from
one PC and my two boses look at it once a day from thier PC's and dont enter
data into it. Thanks!!!!
Click to expand...

PMFJI but... that's a much stronger reason why you SHOULD split the database.
You're at very serious risk of permanently and irrevokably corrupting your
database using a single shared database!!

To compile, type Ctrl-G to open the VBA editor. One of the items in the menu
at the top of the window is "Debug". Select it; one of the lines in the
dropdown menu is "Compile <my project>". Click it; if you get any compilation
errors, fix them before proceeding further.

For splitting the database see the rationale and instructions at
http://www.granite.ab.ca/access/splitapp. If you have never done it before...
now's the time to start.

John W. Vinson [MVP]
 
Ok, I open my database then in VBA I click the Debug -->Compile but it gives
me an option of db1 which isnt my database name? What now? Thanks!!
 
Actually, it probably is the name of the database VBA module at the time you
first added any code.

Try compiling and see what happens.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I cant do it on the machine in question untill monday afternoon but I tried
it on my home machine and nothing happened. But, like I said I dont have any
problems with any PC other than the one at work...
 
John, Ok I tried what you said and everything is fine? My IT has come to our
plant and looked at it and she said she is going to bring another PC in a
week so I will just see if its the PC....Thanks!
 
Back
Top