How to create multiple users in access 2007?

[sweetfalguni]

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

[ChipR]

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.

[sweetfalguni]

can u tell me the steps how do i do

[ChipR]

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.

[sweetfalguni]

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.

[ChipR]

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.

[topher23]

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.

[james raber]

creating the runtime version will not accomplish what you want. I have had to write a complete front end version where users type in a security id and password and then use VB to check what permissions they have and apply those to the form/report. I also use this to cancel opening any form/report that they i do not want them to run. It's a pain, but Microsoft never really does anything to make us developer's jobs easier.