I have a problem with a user using Access 2000 under Win98. When she goes to save a form after entering the data she gets a 'The Save action was cancelled' error message. She then has to exit the form. But the record is saved.

The funny part is that it seems that it is only this one 'computer' that plays up as other users can save with no problems.

As we are just testing the database before releasing it to some 50 or so users I need to resolve this problem to ensure that all goes smoothly.

Any help would be greatly appreciated.

John James
Melbourne, AUSTRALIA

The message is appearing because there is code that is saving the FORM rather than the RECORD. Find the errant code and fix it. When you have multiple users in an A2K database, A2K will not let you update any objects. You can only update data in tables.

Pat, Thanks for your reply - I will take note of what you say. Ironically after having fixed a couple of minor points elsewhere all seems to work O.K. now.

Thanks

John James
Melbourne, AUSTRALIA