Go Back   Access World Forums > Microsoft Access Discussion > Access Web

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-10-2015, 03:15 PM   #1
GingGangGoo
Newly Registered User
 
Join Date: Dec 2010
Posts: 121
Thanks: 7
Thanked 0 Times in 0 Posts
GingGangGoo is on a distinguished road
Linking Access Apps?

My understanding is we can not restrict access within an app, so everyone who can use the app can see all the views, and there is no way to limit some views to certain people only. So, I am curious is it's possible to create linked apps. where one app contains, for example, a contact table and is accessible to all users, and another app, which is accessible to only one or two users, gets the contact table data from the first app. Hope that makes sense.

My challenge is that now that I have a working app, I need to build something for my HR person that is restricted to her and our ED, for tracking employee info. It doesn't make sense to me to have to update tables that would be common to both apps, twice, every time I add, or edit.

What is the best solution for this?

TIA

GingGangGoo is offline   Reply With Quote
Old 12-10-2015, 03:38 PM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,435
Thanks: 40
Thanked 3,368 Times in 3,263 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Linking Access Apps?

If users can see the tables they can see the tables, end of. You limit access by using forms and hiding the navigation window.

using forms and identifying the user (either through a login or by using environ to determine the window user) you can then show or hide options in the menu forms depending on the user.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Building Multiuser Apps with Access winshent General 10 08-07-2014 06:57 AM
Installing Access Apps Acme General 0 09-07-2013 10:22 AM
Access 2013 and SQL Azure Web Apps Rx_ Site Suggestions 0 08-08-2012 12:28 PM
Executing apps outside of Access David Mack Modules & VBA 1 03-28-2000 11:46 PM
Running other Apps from Access SteveR Forms 2 12-07-1999 07:56 PM




All times are GMT -8. The time now is 06:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World