Link to home
Start Free TrialLog in
Avatar of Reyesrj
ReyesrjFlag for Guam

asked on

MS Access 2007 Lockdown

Hi All,

I created an MS Access 2007 database.

Is there a way where a user could access the database and enter information but not be able to alter the forms, tables VBA coding etc.  I would like to secure the work I did so no one could steal my work and or corrupt all the work I did.  I am creating a daily back-up just in case.  

Thank you in advance.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Reyesrj

ASKER

Thank you fyed,

I have done all that you mentioned.  But, if someone knows their way around Access they could easily open everything and gain access to all.  Is there a way to password protect MS Access so no one could access the start button?  Or, something to that affect.

Thanks
Reyesrj,
did you look at the links a posted?
Avatar of Reyesrj

ASKER

Yes, I read a little.
I was a little confused.  Let me read more and any questions I will post them.
Thanks All!
Avatar of Reyesrj

ASKER

Thanks All!