Login Authentication and access control in MS Access-2010

[SKJ]

[FONT=&quot]Using MS access 2010 I have designed a database for a building manager to keep track of rent. There are several sub-managers involved in this. I want to assign a control to only specific reports(not to the database) and have several weird questions-Key point-We have a shared Network and Want to save main database file on that network so only admin can update that file and every user can get the most updated database at all time. These people don't want to use any other DBMS at all except MS ACCESS (which is not really a DBMS)[/FONT]

• [FONT=&quot]Can we keep database in one file as central repository and use other DB files to access that DB in MS access 2010? The reason I was asking is bcoz I want to control access of several users to the same database. [/FONT]
• [FONT=&quot]Can we assign control to specific reports to different level of management? e.g. Manager A can see only room level detail VS. Sr. Manager can see entire organization/buildings detail.[/FONT]
• [FONT=&quot]Can I keep my database safe from non-admin user so they cannot do any changes in that file?[/FONT]
• [FONT=&quot]Does to add login authentication work in above situation? If yes how to assign it to different people to get non- admin view?[/FONT]

I appreciate your time in this.


Thanks!
SKJ

 

[rammudali]

hi
may you split the db into Front and backent. In back end you can keep all the tables and in front end you may use different controls like froms, reports etc based on privilage to want to assign and can have read only access.

 

[SKJ]

How to do that? I am very new to DB and access

-SKJ

 

[rammudali]

hi
better you may attach the db and give you exact requirement to help you

 

[pr2-eugin]

Hi SKJ,

Creating 'FrontEnd' and 'BackEnd' is nothing but splitting the Access file into two seperate files, one file holds all your Forms, Queries, Modules, Reports which we normally term as the FrontEnd. The file BackEnd will contain all the tables that you have in the database.

FrontEnd file can be distributed to as many users as you want, It will have a link to the tables thus it allows concurrent users to access the table, however not the same record at the exact same time.. BackEnd is preferablly placed in a Network location where all users have access to..

Regarding the splitting of the DB, it can be done whenever you feel. Personally I would do it towards the end i.e. before distribution of the files, as this will give only one user access over the file, thus avoiding tampering of information until final product is ready to go.

To create a FrontEnd, BackEnd file all you need to do is.. (In Access 2010) Go to Database Tools-->Under the Move Data group you will have three options of one is 'Access Database'. Click it and the magic happens.. After splitting the DB, on the Front End you can put a password to protect unwanted user access..

ALWAYS MAKE A BACKUP, BEFORE YOU SPLIT. Just in case.

Hope this helps. For more info, visit...

http://www.hitechcoach.com/index.php...atid=24:design