Re: Using Workgroup Accounts on a Network

TC

Thank you for your input. I looked at a number of sites, like you said and
I am a little clearer, but still cannot get my database properly on the
server. I split the database, but when I split it, I cannot access the BE
from other computers. Do I need to used the linked table manager to link the
tables to the BE on the server? Also, do I just place a copy of the front
end on each individual computer, not on the network? If so, then what
happens if any changes need to be made to forms or reports? Do I have to
replace all of the front end copies with the updated version on each
computer? There must be a better way. After I have split the database
properly, and the BE is on the server, do I set up the workgroup settings and
permissions through the BE on the server, or the front end? And you said not
to use the "Join a workgroup," So, how do I get the permissions and workgroup
settings on each individual PC. I am very confused. I am sorry for all of
the questions. I have a lot of experience with Access, but placing it on a
server is new to me. All of your help is much appreciated.

AIMUS

"TC" wrote:

> You're missing a number of things there.
>
> First, you do not normally select the right workgroup file by "joining"
> it (on each PC) using the workgroup administrator program or function.
> You do it by using a shortcut with the /wrkgrp switch in the target.
> Also, you start the process by creating a brand new workgroup file, not
> using the existing one (which you might have done, from the sound of
> it).
>
> If the above info is news, you really need to start again, this time
> following an explicit list of written instructions; eg. the Access
> Security FAQ, often referenced in this newsgroup. It's too hard to get
> it right just by using the wizard & help file.
>
> Second, if the database is shared by several simultaneous users, you
> should split it into a so-called "front tne/back end" structure, to
> reduce the chance of data corruption.
>
> Googling this & other Access groups for /wrkgrp switch, startup
> shortcut, FE/BE & similar terms will give you lots more information.
>
> HTH,
> TC
>
>
.

Relevant Pages

  • Re: Security - Security & User Accounts
    ... You are currently joined to the workgroup file you secured ... password set so Access silently logs you into the database ... and then how can I set up secure logins for ...
    (microsoft.public.access.formscoding)
  • Re: Security Blunder
    ... passwords I setup dont work... ... but part is stored in a workgroup file. ... >> database on my system...All I get is the logon window with ...
    (microsoft.public.access.gettingstarted)
  • Re: Permissions Keep Changing
    ... stored on a central server? ... > be using this database (though usually only about 10 people are in it ... Are you using a single workgroup file, ... Does each user start the system via a shortcut of the following ...
    (microsoft.public.access.security)
  • Re: Using Workgroup Accounts on a Network
    ... Now, I have the database on the server, and all the computers can ... "Joan Wild" wrote: ... >> I am a little clearer, but still cannot get my database properly on the ... > That will use a specified workgroup file *for that session only* and not ...
    (microsoft.public.access.security)
  • Re: Open/Run
    ... permissions but if I created a new database using that workgroup all the ... database with the workgroup I assumed they are part of the workgroup. ... The Workgroup file contains Groups, UserAccounts, and the information about ... All that the MDB cares about is... ...
    (microsoft.public.access.security)
Loading