PC Review


Reply
Thread Tools Rate Thread

access 2007 database secrety and user

 
 
mehdi ghadiry
Guest
Posts: n/a
 
      7th Jul 2007
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

 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      7th Jul 2007
Access 2007 doesn't support user-level security, at least not with ACCDB
(the Access 2007 file format)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"mehdi ghadiry" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
 
mehdi ghadiry
Guest
Posts: n/a
 
      8th Jul 2007
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?

 
Reply With Quote
 
Douglas J. Steele
Guest
Posts: n/a
 
      8th Jul 2007
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.,

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"mehdi ghadiry" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>



 
Reply With Quote
 
mehdi ghadiry
Guest
Posts: n/a
 
      9th Jul 2007
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I allow only 1 user at a time in an Access 2007 database? misswhitneypaige Microsoft Access Security 3 5th Jan 2010 04:08 PM
How can I allow only 1 user at a time in an Access 2007 database? misswhitneypaige Microsoft Access Security 1 4th Jan 2010 10:23 PM
Access 2007 running Access 2000 database - user level security Emma Microsoft Access Security 0 9th Apr 2009 02:33 PM
Securely accessing an Access 2007 database...and are Access 2007 databases secure? clifgriffin@gmail.com Microsoft C# .NET 2 11th Aug 2007 04:49 PM
Access 2007-Sending database files to 2003 user =?Utf-8?B?U2hlcnJpIEQu?= Microsoft Access 1 29th Mar 2007 03:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:49 PM.