Adding Multiple Users to Database

From: T. Garay (moc.etluhcS-noirehpS_at_yhtomiT)
Date: 12/15/03 

Date: Mon, 15 Dec 2003 19:20:20 GMT

In the users section of a database, I can select multiple users and
delete them from being able to access the DB in one keystroke (or so).

Can I do the reverse? If I deleted everyone, is there an SP or a
location that I can select multiple users and grant them access to the
DB quickly?

Thus far, all I've found is to select each user one at a time and give
them "public" access to the database.

(It's a good thing we are not a big company! I tried to restrict
access to all but a couple users to a particular DB only to discover
that I had the wrong DB selected. I had to add each user back in
manually.)

Thanks!

-Timothy

Relevant Pages

  • RE: Merging with Word
    ... You state that your application is not a "spilit" database application. ... you have multiple users and you are attempting to have everyone ... There is no reason for not splitting an application when there are going to ... what I tried is to have Access open a Word Doc and fill in the ...
    (microsoft.public.access.modulesdaovba)
  • RE: Activate/Enable Multiple users
    ... Access should allow multiple users to select, add, modify, or delete records ... Jerry Whittle, Microsoft Access MVP ... The database does not allow multiple users to add or edit records at ... Microsoft Office Access can't save design changes or save to a new ...
    (microsoft.public.access.queries)
  • Re: Choosing a Windows Database
    ... >> use some kind of relational database. ... >> multiple users can access and something scalable and fast. ... >> ADO.NET or ODBC provider. ... >> out there using the DBF type files. ...
    (microsoft.public.vb.database)
  • Re: Network
    ... I was planning to load the database on to the server and have ... it is not *recommended* to have multiple users in the same ... The "best practice" is to split the application into a data file (tables ... not recommend that if the data is mission critical and I would certainly ...
    (microsoft.public.access.gettingstarted)
  • Re: Record Locking
    ... If so, what lock ... "Multiple users open instances of the front end for simultaneous data ... database without any conflict at all. ... but had a field called Price which needed updating by increasing ...
    (microsoft.public.access.queries)
Quantcast