Multiple users problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi. I hope someone can help me.

I have my database stored on a shared network drive. I have created 3
user names, two of which have passwords (User1 and User2). The other
user (User3) does not have a password because they only have read-only
access.

When I open the database from the computer which I secured it from, I
get a login prompt, which is good. When I open it from any of the
computers connected to my large network, the login prompt is not there
and the database just opens with full permissions. I need full
permissions set for two users and read-only set for one user. I've
gone through the wizard, as well as the manual settings and everything
appears to be filled in correctly.

The network consists of over 50 computers, with different Windows
login names. Does this have ANYTHING to do with Access permissions?
How can I get a login prompt to pop-up regardless of which computer/
Windows username I am logged into?

I would appreciate any help you can offer.

.



Relevant Pages

  • Re: Example Code To verify user name and password from table.
    ... users work on a Windows based network, and each has their own login name. ... to log on to the database, forget their passwords etc, plus you are not ... > Does anyone out there have some sample code that shows ho I could save ... usernames and passwords to a table and use the list to restrict access to ...
    (microsoft.public.access.modulesdaovba)
  • why login prompt appear so slow for telnet
    ... Our telnet connection to database become so so slow. ... minute to make login prompt come out. ... Could this be network? ... PING localhost: 56 data bytes ...
    (Tru64-UNIX-Managers)
  • Re: Audacity and Gentoo
    ... > Oracle Black Helicopter Base in Antarctica: `Hey, we've got a database, ... available, especially from Australia's ABC national radio network, ... I don't sync it with the computers, ... There's over 5,000 games in that 15 ...
    (uk.comp.os.linux)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: Replication/Sychronization and security
    ... When put on the network it takes several seconds for those close to ... I am told that our network drives are for data storage (word/excel ... explore the possiblity of replication as a solution. ... >> database to decrease the potential for breach. ...
    (microsoft.public.access.replication)