Access Security

I want to restrict users from updating, input, or delete from the tables and only allow these functions using forms.  Bascially I do not want any users in the tables.  I have tried multiple combinations of the user security features ...

I'm using Access as a frontend Client for a SQL Server based application.  The Access Client is converted to an mde file and users can't access or view the content due to appropriate database properties setting and startup ...

I'm using Access as a frontend to a SQL server.  The Access database contains a number of passthru queries.  I've eliminated access to the database by setting the proper database properties and startup options.  However, users ...

Hi, I need to protect my mdb files (All forms , Queries & tables) from end user to open and change please keep in mind there are more than one users. Thanks for your help Amir ...

Background: I have a database that contains records from multiple departments and currently have a check that prevents departmental users from changing/edit records that do not match their departmental code.  Basically, it is stored in an form where it checks if current users Dept code  = records Dept code if ...

Hi all, I was 'experimenting' with security in MS Access and quickly learnt that it is something that needs lots of knowledge.. something I lacked about the subject a few hours ago.  I would greatly appreciate some advice on removing ...

Hi, I would like to use the built in Access user-level security to secure my multi-user database, but would prefer to simply take the users windows logon rather than requiring them to remember a separate Access username and password. ...

Dear all, I'm using MDW file in my application. After the user login, can I know the password of CurrentUser() ? Thanks. Regards Vensia ...

I posted a question early this morning and still no one has provided any help. ...

I have  a 2000 Database.  I converted to 2002-2003.  I ran the compact/repair.  I ran the Make MDE.  Now my computer just sits, why?  How long does it normally take to create a MDE file?  Also, I have noticed while ...

This has to be simple but I've inherited a DB and am having trouble getting a new user access to it.  I keep getting the message that she doesn't have the necessary permissions... go see the administrator.  We ...

I created a database with user level security for a group of five supervisors, and their manager.  The database is configured so each supervisor is directed to their own form.  The CurrentUser fucntion is employed so each supervisor has the ability to look at their work only.  ...