Workgroup file

[DineshLiyanage via AccessMonster.com]

I have done a MS Access development with access 2003 and it is saved as 2000
format by default. Initially i was working with system.mdw workgroug file and
I finished the development. Then I splitted the database into FE and BE and
my BE file with the server. Then I created a new workgroup file and connected
it with FE application and setup my all user security levels. Now the
application is running well. I have installed my FE file on each user's
desktop. But each user can go to the design view with shift key pressing and
change the workgroup file to system.mdw and read the design. And also they
can import all forms to a new databse without any problem. How can I restrict
this design from users ?

 

[Keith Wilby]

But each user can go to the design view with shift key pressing and
change the workgroup file to system.mdw and read the design. And also they
can import all forms to a new databse without any problem. How can I
restrict
this design from users ?

Apply user-level security correctly. Read and understand the FAQ from MS,
there's a link to it on my web site. You need to follow all of the steps in
sequence omitting nothing, regardless of how trivial it might seem.

Keith.
www.keithwilby.co.uk

 

[DineshLiyanage via AccessMonster.com]

Thanks so much. I got the sequence from your web and done it! Thanks again.
Now my workgroup security is working properly