C
CY
I am about to create a database that will have 3 users. It does not have to
be particularly secure but the client wants to be able to track which of the
3 users makes changes to any record. I figured the easiest thing to do
would be to use the security wizard and then somehow capture the user id
when any changes are made.
Questions:
1) I am using Access 2002, client has Access 2003. Are there any problems
with the security part of this scenario?
2) Should I create the database first and then go to client location to do
the security part?
3) Is there a better/easier way to create log in info and capture it?
4) I have looked at
http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf but I don't know
if there is any reason to do it all manually as the guide suggests when
security isn't a huge priority - it's the tracking that's important to the
client.
5) How and where do you capture user id info when changes to records are
made?
I am technical and experienced at designing databases, but these intricacies
are new to me. I've always created databases with only one or two users,
used for tracking and reporting, never anything like this.
Any help (or examples of another help document) would be appreciated.
TIA!
CY
be particularly secure but the client wants to be able to track which of the
3 users makes changes to any record. I figured the easiest thing to do
would be to use the security wizard and then somehow capture the user id
when any changes are made.
Questions:
1) I am using Access 2002, client has Access 2003. Are there any problems
with the security part of this scenario?
2) Should I create the database first and then go to client location to do
the security part?
3) Is there a better/easier way to create log in info and capture it?
4) I have looked at
http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf but I don't know
if there is any reason to do it all manually as the guide suggests when
security isn't a huge priority - it's the tracking that's important to the
client.
5) How and where do you capture user id info when changes to records are
made?
I am technical and experienced at designing databases, but these intricacies
are new to me. I've always created databases with only one or two users,
used for tracking and reporting, never anything like this.
Any help (or examples of another help document) would be appreciated.
TIA!
CY