The plan is:
1. A password protected backend accdb place in the network share drive
2. Frontend accde connect to the backend by the below code. The variable "theHashPass" store the encrypted password
3. Backend detect a connection attempt to coming in. Decrypt the hashed password. Allow the frontend to link the table if the password is correct
If SSL can be use, then the step to hash password can omit.
I never heard any Access developer try this. Just want to know is it possible or not.
1. A password protected backend accdb place in the network share drive
2. Frontend accde connect to the backend by the below code. The variable "theHashPass" store the encrypted password
Code:
dbs.TableDefs(strTable).Connect = "MS Access;PWD=" & theHashPass & ";DATABASE=" & LnkDataBase
If SSL can be use, then the step to hash password can omit.
I never heard any Access developer try this. Just want to know is it possible or not.