Access Rights

[churchill]

I dont know if this is possible, but i need to add different access rights to a database.
I finish my summer placement in 2 weeks and need to set the database up so that all employees can look at the database but only one can modify it. I know how to do it in excel but i cant seem to get it to work in access. Any suggestions.

 

[Len Boorman]

This can be done with Access Security


BUT

It is a minefield for the unwary.


BEFORE you do anything you need to read and understand the process of securing a database. I have a couple of documents that will help but cannot post them here because they are too large. PM me with an email address that I can send them to

len B

 

[ScottGem]

I dont know if this is possible, but i need to add different access rights to a database.
I finish my summer placement in 2 weeks and need to set the database up so that all employees can look at the database but only one can modify it. I know how to do it in excel but i cant seem to get it to work in access. Any suggestions.

Depends on what you mean by "look at". It also depends on how good you need the security to be.

If you want to allow all employees to add and edit data but only one person to do the design, then just give employees an MDE front end. The person who can edit will have the original MDB front end. They can make changes and redistribute a new MDE.

 

[The_Doc_Man]

Search this forum for Workgroup Security to get an appreciation of how often this topic arises - and how complex it can get. Every answer you need is here, I think, either directly or in web links.

 

[churchill]

I have searched but i still dont know how i would go about adding it to the database.
Sorry.
Any suggestions.

 

[MoNaWaF]

There are many ways to do what do u want.
you can through security or by forms it self ..
sorry i need to check what you've done

 

[churchill]

I havent put anything in place yet. I dont know the best method of completing it. Unfortunatly i cant send anything as the data is confidential.

I just need some guidence into how to complete it and the best way in doig so.

Thanks

 

[jrjr]

Maybe you could make a copy of the DB and delete all of the data from the tables. Then you could post it?

 

[churchill]

i cant unfortunatly as the databse is rather large and currently being used by those in the office. So i have to work around the database at the moment. If that is possible

 

[ScottGem]

In my original response, I asked for some clarification of several points. if you answer those questions we may be able to help further. I don't think attaching even a copy of your database is applicable here. But we do need to understand what you are trying to protect from.

 

[churchill]

Im working for a company on part of a summer placement. I have created two databases for them, the one i am trying to add access rights to contains confidential data, headings and tables. This has been my main problem, as i know what i need to do its the explaining to others that im not very good at. My boss wants me to download extra data of an external site, and create another table in access, all the current tables need to go trhough the new table and match the customer by their id and import what field they come under.

 

[ScottGem]

Im working for a company on part of a summer placement. I have created two databases for them, the one i am trying to add access rights to contains confidential data, headings and tables. This has been my main problem, as i know what i need to do its the explaining to others that im not very good at. My boss wants me to download extra data of an external site, and create another table in access, all the current tables need to go trhough the new table and match the customer by their id and import what field they come under.

This doesn't really tell us much. Also it appears you are talking about two different things.

As far as securing the data, it appears you want to prevent some users from seeing certain data. You can do this by restricting access to the tables through forms and then restricting access to certain forms based on user. The first you can handle by disabling access to the Database Window and converting the front end to an MDE file. While this still isn't absolute it will prevent most people from poking around.

To disable access to specific forms, you can use Access Security. but I find it cumbersome. Generally, I'll check for the user's login ID (use the Environ functions) and then check their access before I load the form. This means maintaing a table of access levels.

when you call the form you ca use something like this:

If DLookup("[Level]", "Users","[LoginID] = '" & Environ("username") & "'") = 1 Then
DoCmd.OpenForm "frmCdata"
Else
MsgBox "you are not authorized to view that form!", vbOkOnly
End If

As for the impoirt, issue, import or link to the external data and then run an Update query matchin on customerID and updating the appropriate fields.

 

[churchill]

thanks for all your help with this post guys. Ive managed to sort it out now.
Thanks