Hi

How can 20 users use the same database? each one of them has right to add 

or modify.

The operative system is NT 4.0, and the database is MS Access2000



Thanks

Hossein

Well... the simplest method is to put your .mdb file on a server visible to

all 20 users, give them all 'full control' perms on the folder where it's

located, and put shortcuts on their desktops that point to the .mdb.  (This

assumes that everybody has Access installed.).  Does that answer your

question, or have I misunderstood it?



Cheers,



-Roy



Roy Pardee

Programmer/Analyst

SWFPAC Lockheed Martin IT

Extension 8487



-----Original Message-----

From: Hossein [mailto:mach3@g...]

Sent: Friday, November 16, 2001 1:21 PM

To: Access

Subject: [access] Multiuser msAccess database





Hi

How can 20 users use the same database? each one of them has right to add 

or modify.

The operative system is NT 4.0, and the database is MS Access2000



Thanks

Hossein

Hi Roy

    I have done already what you wrote, but it doesn't work. The problem is,

when one user has opened the DB, msAccess doesn't give the other users

permission and give this massege that the DB is in use. I want to do

something, that All user get access to DB at the same time and they do what

ever they want, such as delete, add and etc.

    Meanwhile I studied a little. Microsoft has put a function under tools

in msAccess 2000 which can split the DB, so this is the first thing I want

to try on mondag.

    So I don't know what can you suggest now, if the case is more clear for

you?



Many Thanks

Hossein



----- Original Message -----

From: "Pardee, Roy E" <roy.e.pardee@l...>

To: "Access" <access@p...>

Sent: Friday, November 16, 2001 10:37 PM

Subject: [access] RE: Multiuser msAccess database





> Well... the simplest method is to put your .mdb file on a server visible

to

> all 20 users, give them all 'full control' perms on the folder where it's

> located, and put shortcuts on their desktops that point to the .mdb.

(This

> assumes that everybody has Access installed.).  Does that answer your

> question, or have I misunderstood it?

>

> Cheers,

>

> -Roy

>

> Roy Pardee

> Programmer/Analyst

> SWFPAC Lockheed Martin IT

> Extension 8487

>

> -----Original Message-----

> From: Hossein [mailto:mach3@g...]

> Sent: Friday, November 16, 2001 1:21 PM

> To: Access

> Subject: [access] Multiuser msAccess database

>

>

> Hi

> How can 20 users use the same database? each one of them has right to add

> or modify.

> The operative system is NT 4.0, and the database is MS Access2000

>

> Thanks

> Hossein




>




>

>

This is taken from Access help file:



Specify whether an Access database opens in shared or exclusive mode by

default This procedure affects the way a Microsoft Access database is opened

only on your computer. It does not affect the default for users on other

computers.



On the Tools menu, click Options.



Click the Advanced tab.



If you want others to be able to open the Access database at the same time

you have it open, click Shared.

If you want sole access to the Access database when you have it open, click

Exclusive.



Notes



When you open an Access database in a multiuser environment, you can open it

in exclusive and/or read-only mode, even if you specify shared mode by

default. For more information, click .



If you set up security in your multiuser environment, you can ensure that

users don't open an Access database exclusively by denying them Open

Exclusive permission for the database. For more information on removing

permissions, click .



When you open an Access database file (.mdb) in shared mode, Microsoft

Access also creates a locking information file (.ldb) with the same file

name (for example, Northwind.ldb) and in the same folder as the database

file. This locking information file stores the computer name (such as mypc)

and security name (such as Admin) of each shared user of the database.

Microsoft Access uses this information to control concurrency. In most

cases, Microsoft Access automatically deletes the locking information file

when the last user closes the database file.



Hope this helps.



Walt

There are two ways to open an .mdb exclusively.  First, you can do so

explicitly, either through the Open Database dialog (rather than click on

the Open button, hit the drop-down arrow to the immediate right of it &

choose "Open Exclusive") or by using the /excl command line switch.

Incidentally, once you open an .mdb exclusively, if you thereafter use the

list of Most-Recently-Used files on the File menu to get back in, you're

opening exclusively again.



The second way is if you first open the file non-exclusively, but then make

design changes to an object (e.g., form or report).  As soon as you do this,

Access tries to 'promote' the file lock to exclusive until you close the

last object.  See 

http://support.microsoft.com/support/kb/articles/Q200/2/90.ASP 



for details on why & how access does this and



http://support.microsoft.com/support/kb/articles/Q237/9/38.ASP



for details on what constitutes a 'design change' (note that it includes

changes to filter & sort settings!).



So... hopefully this is helpful info.  If your users are opening the file

exclusively using the first method, your fix should be easy--tell them not

to do that.  If your users are opening the file exclusively by accident

using the second method, and they really truly need to alter objects, then

you may end up having to split the .mdb and give each user his or her own

copy of the front-end file.



HTH,



-Roy



Roy Pardee

Programmer/Analyst

SWFPAC Lockheed Martin IT

Extension 8487



-----Original Message-----

From: Caroline & Hossein [mailto:mach3@g...]

Sent: Saturday, November 17, 2001 10:57 AM

To: Access

Subject: [access] RE: Multiuser msAccess database





Hi Roy

    I have done already what you wrote, but it doesn't work. The problem is,

when one user has opened the DB, msAccess doesn't give the other users

permission and give this massege that the DB is in use. I want to do

something, that All user get access to DB at the same time and they do what

ever they want, such as delete, add and etc.

    Meanwhile I studied a little. Microsoft has put a function under tools

in msAccess 2000 which can split the DB, so this is the first thing I want

to try on mondag.

    So I don't know what can you suggest now, if the case is more clear for

you?



Many Thanks

Hossein



----- Original Message -----

From: "Pardee, Roy E" <roy.e.pardee@l...>

To: "Access" <access@p...>

Sent: Friday, November 16, 2001 10:37 PM

Subject: [access] RE: Multiuser msAccess database





> Well... the simplest method is to put your .mdb file on a server visible

to

> all 20 users, give them all 'full control' perms on the folder where it's

> located, and put shortcuts on their desktops that point to the .mdb.

(This

> assumes that everybody has Access installed.).  Does that answer your

> question, or have I misunderstood it?

>

> Cheers,

>

> -Roy

>

> Roy Pardee

> Programmer/Analyst

> SWFPAC Lockheed Martin IT

> Extension 8487

>

> -----Original Message-----

> From: Hossein [mailto:mach3@g...]

> Sent: Friday, November 16, 2001 1:21 PM

> To: Access

> Subject: [access] Multiuser msAccess database

>

>

> Hi

> How can 20 users use the same database? each one of them has right to add

> or modify.

> The operative system is NT 4.0, and the database is MS Access2000

>

> Thanks

> Hossein




>




>

>

Hi

Thank you Roy and the others for your answer. Today I tried to split the

database which is under the tools--> database --> split. After I did it, All

the users (20) could open the database and do what ever they want to do

(delete, add etc.) without any problem.



Again Many thanks



Hossein







----- Original Message -----

From: "Pardee, Roy E" <roy.e.pardee@l...>

To: "Access" <access@p...>

Sent: Sunday, November 18, 2001 9:18 PM

Subject: [access] RE: Multiuser msAccess database





> There are two ways to open an .mdb exclusively.  First, you can do so

> explicitly, either through the Open Database dialog (rather than click on

> the Open button, hit the drop-down arrow to the immediate right of it &

> choose "Open Exclusive") or by using the /excl command line switch.

> Incidentally, once you open an .mdb exclusively, if you thereafter use the

> list of Most-Recently-Used files on the File menu to get back in, you're

> opening exclusively again.

>

> The second way is if you first open the file non-exclusively, but then

make

> design changes to an object (e.g., form or report).  As soon as you do

this,

> Access tries to 'promote' the file lock to exclusive until you close the

> last object.  See

> http://support.microsoft.com/support/kb/articles/Q200/2/90.ASP

>

> for details on why & how access does this and

>

> http://support.microsoft.com/support/kb/articles/Q237/9/38.ASP

>

> for details on what constitutes a 'design change' (note that it includes

> changes to filter & sort settings!).

>

> So... hopefully this is helpful info.  If your users are opening the file

> exclusively using the first method, your fix should be easy--tell them not

> to do that.  If your users are opening the file exclusively by accident

> using the second method, and they really truly need to alter objects, then

> you may end up having to split the .mdb and give each user his or her own

> copy of the front-end file.

>

> HTH,

>

> -Roy

>

> Roy Pardee

> Programmer/Analyst

> SWFPAC Lockheed Martin IT

> Extension 8487

>

> -----Original Message-----

> From: Caroline & Hossein [mailto:mach3@g...]

> Sent: Saturday, November 17, 2001 10:57 AM

> To: Access

> Subject: [access] RE: Multiuser msAccess database

>

>

> Hi Roy

>     I have done already what you wrote, but it doesn't work. The problem

is,

> when one user has opened the DB, msAccess doesn't give the other users

> permission and give this massege that the DB is in use. I want to do

> something, that All user get access to DB at the same time and they do

what

> ever they want, such as delete, add and etc.

>     Meanwhile I studied a little. Microsoft has put a function under tools

> in msAccess 2000 which can split the DB, so this is the first thing I want

> to try on mondag.

>     So I don't know what can you suggest now, if the case is more clear

for

> you?

>

> Many Thanks

> Hossein

>

> ----- Original Message -----

> From: "Pardee, Roy E" <roy.e.pardee@l...>

> To: "Access" <access@p...>

> Sent: Friday, November 16, 2001 10:37 PM

> Subject: [access] RE: Multiuser msAccess database

>

>

> > Well... the simplest method is to put your .mdb file on a server visible

> to

> > all 20 users, give them all 'full control' perms on the folder where

it's

> > located, and put shortcuts on their desktops that point to the .mdb.

> (This

> > assumes that everybody has Access installed.).  Does that answer your

> > question, or have I misunderstood it?

> >

> > Cheers,

> >

> > -Roy

> >

> > Roy Pardee

> > Programmer/Analyst

> > SWFPAC Lockheed Martin IT

> > Extension 8487

> >

> > -----Original Message-----

> > From: Hossein [mailto:mach3@g...]

> > Sent: Friday, November 16, 2001 1:21 PM

> > To: Access

> > Subject: [access] Multiuser msAccess database

> >

> >

> > Hi

> > How can 20 users use the same database? each one of them has right to

add

> > or modify.

> > The operative system is NT 4.0, and the database is MS Access2000

> >

> > Thanks

> > Hossein




> >




> >

> >

>

>




>




>