Hi. Can anyone tell me whether there's another way to secure database other 
than using "User-level security" ?

Firz,

You can use a database password:
    Tools | Security | Set Database Password

You can encrypt the data:
    Tools | Security | Encode/Decode Database

You (rather, your network administrator) can manage access/execute 
permissions to the folder in which the database is stored.

Regards,
Graham R Seach
Microsoft Access MVP
Office DevCon 2007. Sydney Australia. Will you be there?
Sydney, Australia
http://www.block.net.au/devcon/index.htm



"Firz" <Firz@discussions.microsoft.com> wrote in message 
news:D6D58277-F181-4A90-A228-99591922A4F1@microsoft.com...
> Hi. Can anyone tell me whether there's another way to secure database 
> other
> than using "User-level security" ? 

At this moment, I have 2 databases with the exact same designs. The only 
difference are the permissions set to them. I believed that by using 
"User-level security", the administrator can grant users access to different 
tables, forms, queries and etc according to his wishes. So I was wondering 
whether there is any other way to achieve this?

For e.g User A is allowed to access a particular table/form only by 
read-only while User B is allowed to have the permission to have write 
permission on it. 

"Graham R Seach" wrote:

> Firz,
> 
> You can use a database password:
>     Tools | Security | Set Database Password
> 
> You can encrypt the data:
>     Tools | Security | Encode/Decode Database
> 
> You (rather, your network administrator) can manage access/execute 
> permissions to the folder in which the database is stored.
> 
> Regards,
> Graham R Seach
> Microsoft Access MVP
> Office DevCon 2007. Sydney Australia. Will you be there?
> Sydney, Australia
> http://www.block.net.au/devcon/index.htm
> 
> 
> 
> "Firz" <Firz@discussions.microsoft.com> wrote in message 
> news:D6D58277-F181-4A90-A228-99591922A4F1@microsoft.com...
> > Hi. Can anyone tell me whether there's another way to secure database 
> > other
> > than using "User-level security" ? 
> 
>