Inconsistent error

  • Thread starter Thread starter GlennL
  • Start date Start date
G

GlennL

I recently made a change to a database. It is distributed
as a standalone to different offices. I am receiving the
following error message on about 10% of the users
machines. "You cannot carry out this action at the
present time." It occurs as part of a modification to a
record procedure. In order to process the modification 5
forms are hidden in the background and open as you go
through the process. It works on win 95, win 98, win 2000
and Xp systems. Some machines just lock up with this
message. The rest work just fine. The Err.number
is " "in other words no existent. The Err.description
is "Ms Access". Any idea what this message is pointing
to? I have reloaded operating systems, Reloaded Access
even reformated and changed one win 95 machine from Fat
16 to Fat32.
 
Since it works on some machines and not on others, my guess is that there is
a difference in the service packs on some machines.

Go to http://support.microsoft.com and get the latest service pack for your
version of Office. If it is Access 2000 or later, get the latest service
pack for JET 4 as well ("Downloads" section). Apply the service packs to all
machines.

You can read the service pack you have from the Help | About screen. The JET
pack is not shown there, but locate msjet40.dll (usually in
windows\system32), right-click, choose Properties, and look on the Version
tab. If it is less than 4.0.8015.0, you need the update.

The service packs are so important these days that we display this
information on our own splash screen/help|about form. Just use text boxes
with control source like this:
For Access:
=fGetProductVersion(SysCmd(9) & "msaccess.exe")
For Jet:
=fGetProductVersion(fReturnSysDir() & "\msjet40.dll")
Copy the functions from:
http://www.mvps.org/access/api/api0065.htm
 
Back
Top