how do i create multiple users in access 2007

hello,

I want to create 2or 3 users in Msaccess 2007 inwhich first user say namely 'Administrator' has rights to access or edit or delete or modify table,forms,reports.

Second user say namely' Userq' has rights to access only forms where he add records n not able to read or edit or delete table'

And also the file is store in Administrator's Computer so that second user can access the file from Administrators Computer i.e. share document.

Please help

re: how do i create multiple users in access 2007

User level security was removed in Access 2007. The way I handle this is to provide users only a runtime version of the frontend database (.accdr), while I as the administrator use the un-compiled file (.accdb) to connect to the same backend database.

re: how do i create multiple users in access 2007

can u tell me the steps how do i do

re: how do i create multiple users in access 2007

If you have a specific problem, we'd be glad to help. You may want to start by reading Access Help or Deploy an Access 2007 application.

re: how do i create multiple users in access 2007

So i need to download Deploy an Access 2007 application. or Download the Access 2007 Runtime.

It will be nice if you can send me the steps

I m new to Access.

re: how do i create multiple users in access 2007

I can't possibly explain any better than the information in that link. I know it's a bit long, but I don't see any point in rewriting it for you.

re: how do i create multiple users in access 2007

Posting questions on a forum asking others to solve your problems for you is not a substitute for learning it yourself. If you are new to Access, you need to be spending a lot of time with tutorials (functionx.com has some pretty good ones), maybe take an online class or two, and read everything you can about Access 2007 on the MS website.