Access Security in ms access 2007 application

[rana.ankit]

Hi All,

I have created a ms access application with 4 databases out of which one database has all the forms and link tables from other databases.

I want to put security so that no one can access backend tables directly the only option is to enter the data from forms. I cannot create it as mde file so thats not an option.

if anything can be done from vba code that would be appreciable.

Thanks in advance