Intermittent Error 33 message being posted

[Richard I]

Hi
I have two clients reporting that that an error 33 popup messages are appearing on the desktop of the server that is hosting my webserver
The popup is saying that the employee file is not being updated but in fact it is.
Im not using tryfetch

I cannot replicated this error on my local network.
Can I have some guidance on this please?

Thanks Richard

[osquiabro]

have a primary key defined in the form?

[Richard I]

Hi
Thanks for replying but I am a little uncertain as to what you are saying or suggesting?
I call the employees by a  unique key, not the primary key.
The primary key is the recordID
thanks
Richard

[Bruce]

do you have any hand-code in the form in question?
does that hand-code do any table access?

cheers
Bruce

[Richard I]

Hi Bruce,
yes the handcode  accesses the employee file by unique code, gets details, and includes in log as they log in , and makes them                            EMP:LoggedIn   = 1
When logging out access again and  makes them            EMP:Loggedin    = 0

Access:Employees.Update()

Following the C10 posting I have changed to
Access:Employees.TryUpdate()

Im fetching the Employee by login code on a unique key


All works well here but....

Thanks,
Richard

[Bruce]

Hi Richard,

you haven't posted your code block, but it's important to put all the code together into one embed.
And you must open and close the tables you are using as well.

If you have any Unique keys on the table (other than the primary key) or you are changing the primary key value, then you also need to pre-emptivly check for Duplicates.

But as long as you are doing the TryUpdate then at least it's not that line generating a message.

Cheers
Bruce

[Richard I]

Hi Bruce,
I have changed the Updates and Fetches to TryUpdate and TryFetch
and am about to release this version.
 
If the error message persists I will forward the code.
Thanks for your help
Richard