Error 3073

[Raul Sandoval]

I get the "3073 Error" that says "The query must be updatable".
Occurs just in some machines, others with the same software works fine,
somebody knows what happens?

It could be a library registration problem?

 

[Allen Browne]

Raul, if the same query gives different results on different machines, my
first guess is that the version of JET (the query engines in Access) is not
consistent across your machines.

Assuming Access 2000 or later, locate the file msjet40.dll. There should be
only one copy of this on any computer, and it is typically in
windows\system32. Right-click the file, and choose Properties. On the
Version tab, you should see:
4.0.8xxx.0
The xxx digits don't matter, but if you don't see the 8 as the minor version
number go to one of these:
http://support.microsoft.com/gp/sp
http://support.microsoft.com/kb/239114
and download SP8 for JET 4.

It really is important that you have consistent JET versions across your
machines, as there were many bugs in the earlier versions of JET 4, and
inconsistent versions can contribute to corruptions.

 

[Raul Sandoval]

Allen thank you so much, finally it works with the MSJet35 SP3 for all the
machines