Access 2000 multi-user security

31 Oct 2008 7:49 PM

agomez@hudsongroup

I have recent designed a Access database on the server in my office and am
trying to set it up for simultaneous multi-user access and workgroup
security, but have been unsuccessful. When I setup security access from one
workstation, subsequent use of the database from that workstation, prompts me
for a logon and password which was previously successfully setup at the
workstation. If I go to another workstation and access the same database
over the network , the workstation is able to access the same database
without being prompted for a logon. I assume it is accessing the database
under the Admin default. This type of simultaneous access also doesn't allow
for simultaneous record editing or additons. How do I configure the database
for multiple user access for different workstations with security, and at the
same time allow for simultaneous edits, and additons to records in the
database ?

1 Nov 2008 6:17 AM

Tom van Stiphout

On Fri, 31 Oct 2008 12:49:02 -0700, agomez@hudsongroup
<agomez@hudsongr***@discussions.microsoft.com> wrote:

Workgroup Security is an advanced topic. It appears you are guessing
how Workgroup Security works, rather than downloading, studying, and
fully understanding the Security FAQ from microsoft.com before taking
the first step.
Workgroup Security is no longer available in Access 2007 new .accdb
format. Hint, Hint.

-Tom.
Microsoft Access MVP

Show quoteHide quote

>I have recent designed a Access database on the server in my office and am
>trying to set it up for simultaneous multi-user access and workgroup
>security, but have been unsuccessful. When I setup security access from one
>workstation, subsequent use of the database from that workstation, prompts me
>for a logon and password which was previously successfully setup at the
>workstation. If I go to another workstation and access the same database
>over the network , the workstation is able to access the same database
>without being prompted for a logon. I assume it is accessing the database
>under the Admin default. This type of simultaneous access also doesn't allow
>for simultaneous record editing or additons. How do I configure the database
>for multiple user access for different workstations with security, and at the
>same time allow for simultaneous edits, and additons to records in the
>database ?