Multi-user database with common front-end

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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. However, I cannot use a shortcut or individual
front-end 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.

??
 
KarenH said:
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. However, I
cannot use a shortcut or individual front-end on the desktop because
of concerns over updating for changes. Can this be done?
Click to expand...

You can implement Access userlevel security to accomplish this.
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
Click to expand...

Oh, so you have implemented security in Access then?
, 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.
Click to expand...

This is only one reason to split the database. Put just the backend on the
server and give each user a copy of the frontend on their PC. If you need
to redeploy an updated frontend to users you can use a utility like that at
Tony Toews' site to automate this.
http://www.granite.ab.ca/access/autofe.htm
 
Yes, I did implement the user-level security, and put a copy of the front end
on each of the users desktop, but I have to get rid of that, they want
everyone hitting one copy of it -- so I am trying to figure out if the
user-level security that I put in is even going to work. Or if, when my code
hits a reference to the "current user", it will just reflect the first person
that logged into it.
 
KarenH said:
Yes, I did implement the user-level security, and put a copy of the
front end on each of the users desktop, but I have to get rid of
that, they want everyone hitting one copy of it
Click to expand...

You are definitely going to corrupt the database if you go this route.
 
KarenH said:
I have to get rid of that, they want
everyone hitting one copy of it
Click to expand...

"They" being management who don't have a clue what they're doing? Been
there. You need to explain to them the danger of data corruption if "their"
method is adopted. "They" shouldn't be looking in the engine compartment in
the first place.

Regards,
Keith.
www.keithwilby.com
 
Back
Top