Lock past transactions

[samm12]

Hi, I am preparing a sales management project in Access 2000. A new sale made in the "Sales" form can be later altered, meaning that the initial information entered are modified. This can cause serious problems when going back to check sales made.
Anybody knows how to lock access to completed sales records?
Thanks

[ADezii]

Hi, I am preparing a sales management project in Access 2000. A new sale made in the "Sales" form can be later altered, meaning that the initial information entered are modified. This can cause serious problems when going back to check sales made.
Anybody knows how to lock access to completed sales records?
Thanks

Set up a User Level Security System in Access with 'Read Only' Access for the general Users and full access to those who you would want to modify the Sales Data. This is not an easy undertaking, and to be perfectly honest, it is very confusing to anyone not familiar with it. Make sure to backup your Workgroup Information File (System.mdw) in the event you decide to proceed with the Security approach and research it thoroughly. Tools ==> Security ==> User Level Security Wizard will put you on the right path to setting up User Level Security.

[samm12]

Thank you very much for your kind help!!

:)

[missinglinq]

Setting up security does, indeed, seem like a drastic way of simply preventing a previously existing record from being edited, if the title "Lock past transactions" is to be taken at face value!

Why not simply lock existing records?

This locks existing records:

Private Sub Form_Current()
 Me.AllowEdits = Me.NewRecord
End Sub

Since mistakes will be made, someone in authority will need to be able to correct them. I use an innocent looking label, usually the form title, and in its OnClick event allow editing.

Private Sub LabelClickedToEdit_Click()
 Me.AllowEdits = True
End Sub

Depending on the savvy of your users, you may want to take steps to prevent the users from directly accessing the tables.

Welcome to Bytes!

Linq ;0)>