Need help with "Invalid use" error

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

I have an Access 2002 format database running as an .mde in Runtime. One of
the forms is a form/subform combination where the subform is in datasheet
view with a significant amount of code in it. All worked well until
recently. Now when the program is installed on some machines, opening the
form generates an error "Invalid use of dot (.) or !". The form continues
to open, but the subform is blanked out with a white box.
I don't have the error on my development machine and it works fine if a
computer has Windows XP sp2 on it. If I get the error and then install the
service pack, the error goes away and it works again.
I have one machine with SP1 on it and I don't get the error.
None of the destination machines have development software on them, so I
can't check for missing references on those machines.
Can anyone tell me what else to check? Is there a list of files that SP2
updates and I could walk through them for version comparison? Other ideas?
I am open to suggestions. All the searches I have done have ended in
dissappointing results.
Thanks so much,
Beth
 
It appears it is the msjet40.dll that is an old version. However, when I
try to replace it with a new version, it says it replaced it and then
immediately reverts to the old version. Is there some trick to getting it
to allow the replacement?

Thanks,
Beth
 
Don't know what's going on there, Beth, but I don't think it is an Access
issue.

The JET service pack can be downloaded from:
http://support.microsoft.com/kb/239114

Make sure Access is not running, and that you are logged in as a local
computer administrator. If your computer is under network administration, it
might be being rolled back?
 
Back
Top