DB not working on other computer

[Guest]

I complited by access 2003 program/project on my desk top computer. When I
installed the file on my laptop It would not show any of my calcutated fields
from my subforms on my main form. It dosen't make any difference if I have
one or two subforms providing the information. I have several forms set up
the same way and it's the same on all of them. I don't believe its the
program because I can reinstall it on my desk top and it run OK. Both
computers have the same version of access on them. Any suggestions would be
greatly appreciated......lyndac

 

[Douglas J. Steele]

Do you get any error messages?

Access databases reference external libraries. A common problem is that
there's a difference between the external libraries available between
computers. You might take a look at my December 2003 "Access Answers" column
for Pinnacle Publishing's "Smart Access", entitled "But it worked
yesterday!"

You can download the column (and accompanying database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Guest]

Thanks for the reply and the information. There is lots of information in
your article, it will take me a while to check everything, but I wanted to
answere your question regarding the error messages. No...no error messages. I
tried a few things and this is what I came up with in the mean time. I have
the same problem on a third computer also. The MS Office/access 2003 program
I just got a month or so ago. I loaded it the same on both computers with one
exception. On the laptop I didn't load the SP1 that came with the Disc set. I
removed it 2X and re-installed it. What I found out is that before I
installed the service pack it wouldn't work. B4 I loaded the SP1 I ran
"Detect and Repair" from the help menue and it found no problems. After I
loaded the SP1, it picked up the calculated fields on the sub forms. Of
course I still have a problem with the 3rd computer, but I will investigate
whats going on with the libraries. I will have to uninstall it again and
check B4 and After the SP1. If any of this makes sense, let me know, I would
appreciate any additional information or reasoning for what's happening.
Regardless I will let you know how I made out....Thanks a lot Doug.....lyndac

 

[Guest]

The problem, more than likely, is a "missing" or "broken" library reference
on the offending machines ...
A "Missing" reference means that the files needed for a specific library are
either not installed in the machine .. or that they are not properly
registered on the machine give the probelm ...
A "Broken" reference means that the files for the specific reference may be
installed on the machine .. but are not located in the same location that
they are on the machine where the application was authored ...

You need to check your Library References on the offending machine to fix
this problem.
This is usually caused by inserting a non-standard ActiveX control in the
app that is not native to Access ...

R. Hicks

 

[Guest]

Thanks for the input Ricky,
I'am convinced (open mouth insert foot) that the problem is directly related
to the MS Office/Access 2003 program. I don't know if I have a defective
program or if it is simply a quirk with my computers. I do know that the
problem is fixed when I install Service Pack 1 (kb842532). Let me say up
front I do not know very much about access and I struggle with it like all
new users, and find this site very helpful. Having said that, the project I'm
working at has no imported or special ActiveX controls and is very similar to
the Northwind DB. The problem I'm having should be relatively common (watch
out mouth here comes the foot again). It's a form with one or two sub forms
that have simple calcutated expressions. All I want to do is bring the
results down to the main form. I some what understand what you and Doug
referenced to regarding libraries and their relationship to projects. For the
record I checked my library references before and after I installed the SP1,
and found no difference in them or bewteen by desk top or laptop. Same
priority, same file names. In this particular project I am only showing 4 (1)
VB for App, (2) MS Access 11.0 Obj lib, (3) OLE Automation, and (4) MS
ActiveX DO 2.1 Library. I am using a registered MS Office program, on both
computers. I looked into what MS had to say regarding the SP1. What I found
may or may not explain the problem. In Article ID 872834
http://support.microsoft.com/kb/872834/ In one of the fixes it says "If you
have a complex form that has several levels of nested calculated controls in
Access 2003, some of the conditional formatting is not applied to the
calculated controls if there are controls that contain expressions"
"Conditional formatting is not applied to calculated controls in a complex
form" I'm no expert but is this what I'm having problems with? After
installing he SP I initally got security warning regarding Unsafe Expressions
are not blocked. "To Block unsafe expressions MS Jet SP8 or later must be
installed." I really don't want to address that here, I'm kinda burt out on
the simple stuff. As always, Thanks again. Any feedback or comments are
really welcome....lyndac