Re: Problem with After Update (and other) events

I tried most of what was suggested, nothing has changed. On the other hand, I
concentrated the problem into a small test case with only one little table,
and the simplest forms to show the problem. Is there a way to include the mdb
file in such a message? I could type here the event procedure, but this
wouldn't make sense, since the procedure is standard and the problem starts
before it would be called.
--
Jancsi V


"Allen Browne" wrote:

There are several possible factors here.

First thing is to make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilities | Compact/Repair

Next check your references are fine on each computer. Since you are running
different versions, see:
http://allenbrowne.com/ser-38.html

Next is the problem if the incompatible binaries between versions. The
compiled code is different in each version. The newer version can handle the
older binaries, but not the reverse. In a perfect world, the older versions
would just ignore the binary they cannot read from the later versions, and
compile with their own, and the newer versions would then be able to handle
that without problem. In practice, it doesn't work like that. You need to
explicitly decompile when you switch version, and especially when you switch
back.

Decompile the database by entering something like this at the command prompt
while Access is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact again.

Sometimes these issues are so stubborn that the only solution is to
decompile, and then create a new (blank) database and import everything.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jancsi V" <JancsiV@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:07984CF3-1132-4D66-9BCF-A3295F86A247@xxxxxxxxxxxxxxxx
This seems to be an old problem. I have seen several questions but no real
good answer. What I have now is the following.

A form with a combo box to select records using the AfterUpdate propery.
It
is smple, it works, in current access it is even created by a wizzard.

On one of the computers I use (computer A), this does not work anymore. I
get the error message: "A problem ocurred while Microsoft Access was
communicating with the OLE server or ActiveX Control."

I create the same sample problem on another computer, B, and it works. I
copy this .mdb to computer A - it works. On computer A I add a new form
(same
as the other), again with a combo box: error message. The new form works
as a
form, it can display the table data, etc. It seems that the event of the
combobox is not handled properly.

There is computer C, I copy the (good) sample file from B, no problem.
There
too, a new form is added, with combo box, it works fine. I copy the file
from
computer A (the one that did not work), it doesn't work here either. There
is also computer D: The "good file" created on B works, new form can be
added, no problem.

On computer A I changed the event from using VB code finding a record to a
very simple one: run a macro to give a sound. This worked. I changed the
macro to set a value of a textbox on the same form, this does not work
anymore.

Computer A: Win XP Pro En, Office 2003 Pro Hun
Computer B: WIn XP Pro En, Office 203 Pro Eng
Computer C: Win XP home, Office XP Pro Eng
Computer D: Win XP Pro Hun, Offce 2003 Pro Hun

I am almost sure computer A did not have this problem until about a week
ago.

Can anyone suggest what I should do?
--
Jancsi V


.

Relevant Pages

  • Re: Problem with After Update (and other) events
    ... If the problem persists even after the decompile, compact, and create-new-database on the problem machine, and all other factors are in order, and it works on all other machines, there could be a problem with that machine. ... Then compact the database: ... Win XP Pro En, ...
    (microsoft.public.access.forms)
  • Re: Problem with After Update (and other) events
    ... Decompile etc. had no effect. ... new database, nothing in it except a form with a combo ... Win XP Pro En, Office 2003 Pro Hun ...
    (microsoft.public.access.forms)
  • Re: Problem with After Update (and other) events
    ... First thing is to make sure the Name AutoCorrect boxes are unchecked under: ... Then compact the database: ... Win XP Pro En, Office 2003 Pro Hun ...
    (microsoft.public.access.forms)
  • Re: Problem with After Update (and other) events
    ... to the other machines. ... Decompile etc. had no effect. ... new database, nothing in it except a form with a combo ... Win XP Pro En, ...
    (microsoft.public.access.forms)
  • Re: How to regenerate (or update) an sld file ?
    ... There are also embedded and enabling features that are in XP Embedded that are not in XP Pro such as EWF, FBWF, etc. ... I was trying to answer your question "how update the database to reflect this update " so I guess I don't understqand what you are asking. ... I've already written my second question, but I will try to rephrase it. ...
    (microsoft.public.windowsxp.embedded)