Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / November 2005

Tip: Looking for answers? Try searching our database.

Multiuser database with common front end

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KarenH - 31 Oct 2005 21:15 GMT
I have a database that requires two separate groups of users -- one will have
read-only access, the others will be able to change data.  Furthermore, the
forms in the front end will display differently depending upon the user group
of the person signing in.   The shortcut to the app contains the workgroup
and path, as well as the userID of the person logging into the app.  
However, they do not want to use individual front-ends on the desktop because
of concerns over updating for changes.  Can this be done?  Can I have
separate users without a separate front-end?  There will be as many as 15
people hitting the application at one time.  I currently have it keying off
the CurrentUser and the group they are in, but if multiple people are hitting
one common front end on a server, I'm thinking the currentuser will only be
the first person to sign in.  

??
Joan Wild - 31 Oct 2005 21:56 GMT
Answered in another newsgroup.  Please don't multi-post.

Signature

Joan Wild
Microsoft Access MVP

> I have a database that requires two separate groups of users -- one
> will have read-only access, the others will be able to change data.
[quoted text clipped - 12 lines]
>
> ??
Larry Linson - 01 Nov 2005 03:40 GMT
See Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm for an Auto FE
Updater. You do NOT want to share a Front End, because that will
significantly increase your chances of corruption.

 Larry Linson
 Microsoft Access MVP

>I have a database that requires two separate groups of users -- one will
>have
[quoted text clipped - 17 lines]
>
> ??
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.