am in the process of finalizing my access vba project, read a lot of ways how to secure the back end tables in the server however they are quite complicated and needed to re-touch my fe codes ... just askin' maybe there is a simpler way to do it... thank you guys ...
-
-
Simpler than what? What have you tried? What version are you using? -
Sir seth, actually I haven't tried anything yet .. but as I read some procedures, I need to put codes on my FE and do something else ... am using Access 2003, I want to have a security within the tables itself by not doing some modification on my FE...Comment
-
What kind of things are you wanting to protect from? Just design changes? You could encrypt your BE which would make it so that only people with the password could make changes. I'm not sure how well this works in Access 2003 though.Comment
-
yes sir seth, something like that ... to encrypt the BE is that possible to do without touching my FE?Comment
-
You would have to relink the tables and then provide the password at that time, but there is no code involved and then once the connection is made, there is no difference.Comment
-
oh thank you! .. let me try to re-link them back ...thank you again as always sir seth.Comment
-
You should be aware though that anyone with access to the front end can see the data on the backend unencrypted.Comment
-
any other suggestion sir rabbit?Comment
-
Yeah. Don't use Access if security is a big concern.
But pragmatically speaking, most people don't have a choice. What you need to know is that there's nothing you can do to secure your data that can't be undone.
How difficult you want to make it for the other user depends on your requirements. And what we would need is clear concise requirements. Just saying you want to secure data is extremely vague.Comment
-
actually I just wanted a password to the BE so that other users wont able to make changes or edit the tables ...Comment
-
For them to be able to connect to the backend, the password will be needed. And if they're connected, they can make changes. There's no way around that in Access.Comment
-
They can make changes to the data, but not the design. Which are you wanting deanvilar?Comment
-
to make changes for the users is ok... but not other personnel who's not entitled to go into the system itself...Comment
Comment