access 2007 database secrety and user

M

mehdi ghadiry

hello every one
I am creating a database with access 2007 and i Want to define user
and level securety but i can't.
plese help me
 
D

Douglas J. Steele

Access 2007 doesn't support user-level security, at least not with ACCDB
(the Access 2007 file format)
 
M

mehdi ghadiry

tank's for reply
If I want to any one can't to see my form or change it and my
data ,what is solution?
 
D

Douglas J. Steele

Why would you have a form if you didn't want anyone to see it?

To prevent them from changing it, you can convert the ACCDB into an ACCDE
(the equivalent of converting an MDB to an MDE)

To be honest, I don't know what options there are, if any, to protect the
data.,
 
M

mehdi ghadiry

Ok Douglas J. Steele

my english is not good. sorry!

you are right, but in my database i have several forms and sevral
users. in access 2003 I set one form in startup and depend on Current
user automaticaly recive their own forms and can't see another forms
to use that. in access 2007 i can't set current user function to
recive their own forms. is there any solution?

I have anather quation if is posible.

in access 2003 I have created one database and secured that. other
user when click on file without using shortcut to open with
"Security.mdw", they recive one message that they have not necessary
permissions and can,t open that file or can't import forms, tables....
to another file. but in my new database i can't do same process to
prevent user to see startup form or import forms, tables...... i was
read sevral article about "admin" user and set my admin with password
but i can't prevent other pc admin users to open access file. when I
open file in other pc without using shortcut to open with
"Security.mdw", i can't see Workgroup user accont. only user is
"admin" and owner my objects is unknown.
in last 14 day i am realy confuse for tow problem.

I am waiting to your help
thank's very much
mehdi ghadiry
 
Top