Hi, I need some guidance on access file encryption. My database will only be stored in one PC and all user can only access the file solely from that PC. I have created a virtual hard disk (VHD) on the PC and save the database in inside the VHD. I have split my database table and save the file in ACCDE format. The accde file was copied to my desktop so user will just access the database from desktop without going to the VHD.
I tried to encrypt the accdb file and when user access the accde file, they also need to key in the encrypted password. When user enter the password, it also means that user can access the accdb file to see the form, queries etc. How can I go about doing it such that user will not be able to view the forms etc? Similarly, for the backend (split database), how to encrypt so user unable to see the table data? And any ways to prevent user from copying out the accdb file to another PC?
I have read up on some of the forum thread and I am still very confused about it. Or did I do it wrongly?
There are only 3 files in the VHD (image attached).
I tried to encrypt the accdb file and when user access the accde file, they also need to key in the encrypted password. When user enter the password, it also means that user can access the accdb file to see the form, queries etc. How can I go about doing it such that user will not be able to view the forms etc? Similarly, for the backend (split database), how to encrypt so user unable to see the table data? And any ways to prevent user from copying out the accdb file to another PC?
I have read up on some of the forum thread and I am still very confused about it. Or did I do it wrongly?
There are only 3 files in the VHD (image attached).