Solved

Permissions Necessary To Refresh Links

Posted on 2008-11-02
16
311 Views
Last Modified: 2012-05-05
What permissions do I need to give the users so that they can refresh links to linked tables. I use the refreshlink method to refresh at login. Also, I have seperated my front-end from back-end (I did this after creating my workgroup).
0
Comment
Question by:bejhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
  • 4
  • +1
16 Comments
 
LVL 75
ID: 22863998
The folder containing an MDB must have 100% Full Permissions in order to function correctly.

mx
0
 
LVL 85
ID: 22865704
Users must have Read Design ability for Tables in the BE, and must have the permission to Add New Tables in the FE. Also must have basic Read/Write for those tables as well.
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 22866573
Take a look at:

Microsoft Access Security FAQ available in the Download Center
http://support.microsoft.com/kb/207793

  The permissions required to relink tables varies by the method you use.  The answer to your question is in there along with a whole lot more then you problably want to know about security<g>.

  Well worth a read.

JimD.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 75
ID: 22868915
Of course, my assumption is ... that once the links are 'refreshed', the users will then be using the MDB - requiring full permissions.

mx
0
 
LVL 58
ID: 22869906
<<Of course, my assumption is ... that once the links are 'refreshed', the users will then be using the MDB - requiring full permissions.>>

  Yeah, but you need those with or without user level security in place.  One would assume they are already in place since the database was already being used.

JimD>
0
 
LVL 75
ID: 22869917
You know ... I missed the 'workgroup' part, sorry.

mx
0
 
LVL 58
ID: 22869966
<<You know ... I missed the 'workgroup' part, sorry.>>

  Been there done that!

JimD.
0
 
LVL 1

Author Comment

by:bejhan
ID: 22870412
I think I might actually ditch MS Access security all together and just implement my own. The Access security is pretty annoying to use. Is there any reason you would recommend against this?
0
 
LVL 75
ID: 22870567
It's not going to be that easy really to roll your own.  Not sure I would reinvent the wheel in this case ... assuming you really need security.

mx
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 22870882

  Access user level security is the only real way to protect your tables but it's a pain to use (now that I say that, I'm wondering if a database level password would be sufficent now that it's been beefed up).  But since it's easy to crack (to a Google search) it doesn't seem worth the effort.

  If you goal is to control access to forms and reports, then yes, I would just roll your own.  If security is really a concern because of the data itself, then I'd be looking to use SQL server as a back end with your own security in the front end to control form and report access.

FWIW,
JimD.
0
 
LVL 1

Author Comment

by:bejhan
ID: 22871423
Well I may just be being overly paranoid here. The application is for a group of under 20 users. I have 3 levels of users: team leads, full users, partial users. Team leads have access to admin tools etc., Full users can do everything except admin tools, and partial users can add additional information to records and pull reports. I have already coded it to check user type, show them the appropriate menu, and show them only the records that belong to them, etc. I have startup so you need the shift key to even access database objects.

Now I am fairly new to Access, this is really my first application that was more than a few users and where more than one user would be on at a time so I figured I should set permissions as secure as possible, only let them read/write tables that forms they were accessing were bound to, only let them read forms they were allowed to access, etc. Now I am running into problems where the permissions I have set is not allowing the user to do things I want them to (such as refresh links). Would compiling this into an MDE and disabling the shift button be sufficient with the coding I have already done to keep my database secure and just giving all users full permissions (and my backend with a password)?
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 100 total points
ID: 22871504
"Would compiling this into an MDE and disabling the shift button be sufficient with the coding I have already done to keep my database secure and just giving all users full permissions (and my backend with a password)?"

And MDE will prevent users from being able to:
1) See any code

2) Make design changes to Forms, Reports  (and Modules 1 above).

It does nothing to protect or secure data in any way.  However, with the shift key scenario, then assuming they cannot get to the database window (in the MDE) ... AND ... you have the back end Password protected - along with whatever code you already have - you *might* be ok.  Note that the database password in A2003 and prior is easily hacked.

mx
0
 
LVL 1

Author Comment

by:bejhan
ID: 22871778
Its just I don't have any reason to think that someone would be trying to get at the data. The application is for use in a government office so the security is already pretty good there for people trying to hack their way in. I really just wanted to stop users from doing things like: "I made a small mistake in the data and now I can't change it I'll just quickly go into the tables and change it".
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 100 total points
ID: 22871797
Gov't = Secure = Oxymoron, LOL.

OK ... based on what you are saying, I would say MDE + BackEnd Password = Reasonable.

mx
0
 
LVL 1

Author Comment

by:bejhan
ID: 22872579
Thanks for all your help guys.
0
 
LVL 75
ID: 22872597
You are welcome.

mx
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question