Only One User Can Acces DB ?

[Guest]

I just completed the installation, and some modification, to a database that
we are using in our office. We used to have one that did 90% of what this
one does, but someone incorporated pictures, etc. to make this one 'snappy"
and our boss likes it.

The problem is that for some reason only one user can access the information
at a time. This application is running on a network and needs to allow
multiple (up to about five) users access at one time.

I realize that only one person can change a record at any one time, but this
is not the case here. If user 1 has the 'frontend' open, no one else is able
to open the file. A message stating something along the lines of another
user has the file open in exclusive use is what is received.

Can anyone give me an idea where to start looking? We need this information
quickly! (Wish my old system were up and running now, I didn't have this
problem!)

Thank You in advance!!

 

[Rick Brandt]

I just completed the installation, and some modification, to a
database that we are using in our office. We used to have one that
did 90% of what this one does, but someone incorporated pictures,
etc. to make this one 'snappy" and our boss likes it.

The problem is that for some reason only one user can access the
information at a time. This application is running on a network and
needs to allow multiple (up to about five) users access at one time.

I realize that only one person can change a record at any one time,
but this is not the case here. If user 1 has the 'frontend' open, no
one else is able to open the file. A message stating something along
the lines of another user has the file open in exclusive use is what
is received.

Can anyone give me an idea where to start looking? We need this
information quickly! (Wish my old system were up and running now, I
didn't have this problem!)

Thank You in advance!!

ALL users must have full permissions to the folder where the file resides.
Actually, by "full" I mean they need...

File create
File execute
File modify
File delete

(yes they need the last one)

 

[Douglas J Steele]

ALL users must have full permissions to the folder where the file resides.
Actually, by "full" I mean they need...

File create
File execute
File modify
File delete

(yes they need the last one)

<quibble>
I think they can get by without delete, but there will be problems
compacting the database (since the LDB file will imply to access that the
database is open), so for all practical purposes that's true.
</quibble>