security question

[chavez_sea]

Hi members,


I have a situation for which I would like some advice.

I have a database, with data for 6 different regions. One employee is responsible to update several tables with data for his/her region and run reports. I need to set up security measures. All employees enter data through a front end to the tables on a main computer. Not sure how to proceed.

I would be grateful for your assistance.

Thanks
Cristina

[CJ_London]

left it a bit late to add this type of security and 'One employee is responsible to update several tables with data for his/her region' sounds like your data is not normalised so is likely to make the whole thing more complicated. Not enough info to provide anything more than an outline of what is required

1. you will need a login procedure to identify users - or use the environ("UserName") function to return their windows login
2. you will need a table or tables to provide rights for each user - basically what they can see, what they can do
3. you need to apply this to the tables as part of the process code (if not normalised) or to the records as a query (if normalised)

[Micron]

I need to set up security measures. All employees enter data through a front end

The same front end db file? Not recommended.

[orange]

Christina,

See youtube videos by Steve Bishop (for a good start)

Classic Login screen
Securing Your Front End

As others have said, best to design this requirement from the outset of the project. Multi-user requires front end /backend split database with a copy of front end on each user's PC.

Good luck with your project.

[chavez_sea]

Hi,
Thank you so much for directing me to Steve Bishop's videos. They are helpful and easy to understand. It was just what I needed. Reply

Regards,
Cristina

[orange]

Glad you found the videos and info helpful. Happy to help.