July 7, 2008 at 4:19 pm
I am developing a system using the MS Access 2003 tool. The backend is SQL Server MSDE2000.
I want:
- Disable the user from directly editing the SQL Server Linked tables objects in the Access database window. He can only view/edit the data through the MS Access front end forms.
- When the user opens these linked tables objects in the Datasheet view, I want him to see only the encrypted data as # symbols instead of seeing the real data.
Thanks
July 8, 2008 at 12:38 pm
Have you tried compiling the project to an ade file for end-users? (Access Help has instructions on how to do this.)
If you do that, you can hide the tables, etc., from the end-users. You can also make it so they can't get into your modules, the code in your forms, etc.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 8, 2008 at 1:25 pm
Thanks for this suggestion. I will try it.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply