Access database security 1

[nissan240zx]

Hello All,
I am trying to improve the security I have on my access database from just basic network folder permissions
My system works with a front and a backend database. ADO data connections used to send/receive data. Opened at time of transfer and closed when transfer completed.
Front end database has no access to back end tables outside the VBA procedures that handle data transactions
Backend database updated daily via batch file.

These are few suggestions I got:
- Back end database secured with Microsoft Access password security
- Front end database local to user’s computer to Polls Windows to obtain user identity.
- Limit access to features limited based on user identity
- Back end password added to the connection strings in the front end code
- Back end password added to the batch file command line arguments

I know how to add password in Access. But other things I am not sure.
Any leads or advice in this regards will be highly helpful.

Thanks,
Nissan

Nissan 240 ZX...best Nissan Ever

 

[DotNetGnat]

- Front end database local to user’s computer to Polls Windows to obtain user identity.

[blue]when you say this i think you are referring to the Active Directory Service. Here is a nice link that give info on AD
[/blue]

- Limit access to features limited based on user identity
- Back end password added to the connection strings in the front end code

[blue]This you can achieve both at the front-end and back-end.I am not completely sure of how you achieve at the bacj-end level using access. But for example if you consider SQl Server database then we can limit users even at the table and column level.

As far as the front end is considered. You can easily achieve this by implementing login interfaces that use a separate database table with users info or you can use Active Directory information.
[/blue]

-DNG

 

[nissan240zx]

Sounds a plan for start..
Let me try these methods and see what happens..

Nissan 240 ZX...best Nissan Ever