nissan240zx
Programmer
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
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