Split Database - FE edits allowed?

Can you assist me with this, I have no idea how to start the coding off.

as it stands, I am the most knowledgable in my dept in access, so i am not
really worried about joe trying to get into anyone elses data. Also, Will i
have to base each form on each indvidual's computer. Please help!

"John W. Vinson" wrote:

On Tue, 22 Sep 2009 15:25:04 -0700, Chantel33
wrote:

John

Yes, i am concerned about joe schmoe editting someone else's entry in the
form, how do i restrict each user to their own entries?

Well, it depends on how knowledgable, determined and skilful Joe is. You'll
need to use VBA code to get the user's logon ID (and trust that Bill didn't
tape his password to the side of the monitor where Joe could see it), and base
the form on a Query using that ID as a criterion; lock down all your code by
giving users only a properly secured .mde file rather than the full .mdb. This
can be quite a lot of work, and even then it can be broken by a knowledgable
and determined user.
--

John W. Vinson [MVP]