User Permission

[Denver]

Hi,

I have a database in access 2003 I want to create a User permission.

how would I start? Pls. need your suggestion on how should my table be look
like and my query? I don't need to split for now my database I just want a
simple sharing that a number of user can use, because I am not yet done with
my design for the database. Will the purpose for now of sharing to other user
is for data entry.

thanks, I appreciate any suggestion and help

 

[Keith Wilby]

Hi,

I have a database in access 2003 I want to create a User permission.

how would I start? Pls. need your suggestion on how should my table be
look
like and my query? I don't need to split for now my database I just want a
simple sharing that a number of user can use, because I am not yet done
with
my design for the database. Will the purpose for now of sharing to other
user
is for data entry.

thanks, I appreciate any suggestion and help

If you're not done designing then you're not ready for users to enter any
data. And if you have more than one end user then you *do* need to split.

There's a link on my web site to the MS FAQ on user-level security. That's
what you should read and understand if you want to set user permissions.
Here's some more information on splitting:

http://www.granite.ab.ca/access/splitapp/index.htm

Keith.
www.keithwilby.co.uk

 

[Revned]

thank you keith wilby

now i am done creating a new database can you also show me a link of how to
start making user persmission that is attached to my mainswitchboard.

 

[Keith Wilby]

Follow the link to the FAQ on my web site.