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]
>
> ??