More than one user at once?

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have been attempting to ensure more than once person can use a particular
database at once. Going on previous advice I received here, I checked the
network folder holding the database , as was advised that all users of the
database require Read, Write, Create, and Delete privileges
for the entire folder and not just the database file.

So I selected the folder properties in Windows Explorer, and unchecked the
read only check box. Afetr applying the change and OK'ing the "are you sure
you want to unset the read only" prompt, the read-only check box appeared to
have been cleared. However, when the folder properties were checked again
it had reverted to read only. This is on a company XP network P:\ drive.

Can anyone advise? All I want is to ensure that 2 or 3 users can use the
database at once. I was under the impression that Access was configured for
muli-user 'of of the box'? I have dbl checked that 'Exclusive Access' isn't
checked in Options, and aren't sure what else to do?


Any help greatly appreciated.

Hopefully yours,

-Jay-
 
In order to map drives to folders on a server, you need to use shares (you
map a drive to \\server\share). It's possible that the permissions on the
share are interfering with the permissions on the folder.
 
What you need to change is the SECURITY settings on the folder (2nd tab in
the properties window). You may or may not have permission to do this
depending on how the file server is set up and the permissions you have been
given on the folder by your IT folks.

That is where you will find ways to authorize users and groups to modify,
read, write, execute, etc.
 
Does the database really have to be split? I only want two users to have
simultaneous use. This is what I have done so far:

- Checked security settings on the folder (2nd tab in
the properties window), and confimed that the users have modify,
read, write, execute permisions.

- Ensured that 'shared' access is checked in Tools-Options

Both users can have the mdb open at the same time, but if either tries to
use a form that the other is using (which will probably be showing some
query output) they get the following error:

'Run-time error '3009'
'You tried to lock tabkle 'tblContactList' while opening it, but the table
cannot be locked because it is currently in use. Wait a moment, and then
try the operation again.'

I have tried all the different record-locking options, but the error
persists.

If anyone can advise how I can enable 2-user simultaneous use without the
above error I would be *so* grateful:-)

Hopefully yours,

-Jay-
 
Access MDB files are not capable of being stable for a single user and
a single record.

whoever told you to use MDB files was wrong; and you need to start off
on the right foot.
Use a real database

Sorry kid, Microsoft doesn't give a shit about access-- I can prove it
because the software is so buggy that they must have done this on
purpose.

I reccomend using mySql and also learning PHp.

Microsoft can eat shit for breakfast for all i care.
They have been abusing customers for way too long and I'll be damned if
i sit quietly by while another loser learns MDB.

MDB is a joke; it was obsolete before it came out.

-Aaron

SPLITTING doesnt really do anything.

Keep your data in a database and screw MDB files.

Use Access Data Projects; they are quite nice and powerful
 
From this and other posts I suspect you're just a troll, but there is the
possibilty that you're actually incompetent and prefer to blame the tool.
 
Back
Top