access

[frank]

I create a database (table, form..) and set security for
user. I save it locally and test the security permition
it seems ok. I copy the data file to network and open it
from network. When I open it which no longer ask for user
name and password and directly open it but when I click
form or table, I do not have admin access. Any one please
help!

 

[Joan Wild]

I create a database (table, form..) and set security for
user. I save it locally and test the security permition
it seems ok. I copy the data file to network and open it
from network. When I open it which no longer ask for user
name and password and directly open it but when I click
form or table, I do not have admin access. Any one please
help!

That suggests that the Users Group still has open permission on the database
object. You shouldn't be able to even open the mdb without using the
correct workgroup file. You'll need to copy the mdw to the server, and give
users a shortcut to open the mdb. First correct the problem with the Users
Group.

The shortcut would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[frank]

I copy the mdw to the server now it promp for user name
and password. I enter user name with admin right but only
one form could be open which I assign to user right.
I could not log on to user account also.