save action was cancelled!

[Guest]

Hello everyone,

I have a receipts form which takes payments, after a lengthy procedure the
user gets to save the payment however the above message appears on screen
leaving the user frustrated.

I have 2 copies of the database, one test database, which im working on and
one which my users have access too, on my test database i am able to save
receipts and on the identicle one they use the error message occurs. I have
gone through the code line by line and it is identicle on both.
Any suggestions on why it works for me but not for others?

With much thanks

Amit

 

[Arvin Meyer [MVP]]

If your database is properly split into data in one database and code and
object link to the data in another, you can give an exact copy to your
users. If the problem then continues, it has to be one caused by permissions
or record locking. Make sure that the users have all permissions with the
possible exception of Full Control, and that they are not exclusively
opening the database (thus keeping others from saving). Set the
record-locking to either no-locks or edited record.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

thanks for the feedback, just been really busy here but i still cant get that
form to work. I did take a look at the permission settings for each user and
apart from teh administrators, most of them have full data user privledges.

The database opens in shared mode and defaults to lock edited record so that
should not get in the way. I checked the form properties and its also on lock
edited record.

The database is fine if a single user is using it, but if there are 2 users
using it the second one cant save. the error message appears and problems
start occuring.

Hope someones got some more tricks up their sleeve.

With much frustration,

Amit

 

[Arvin Meyer [MVP]]

That certainly sounds like there are no delete permissions for at least one
user, on the server. When there are no delete permissions the LDB file
cannot be deleted and that keeps a second user from being able to lock the
records he needs to update/save the file.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access