multiuser how-to questions

[Redbeard]

I've Googled the group for advice on multi-user problems, but I'm still
not certain what my problem is.

I've created the database in Access 2000, split it, put the back-end on
the server and put the front-end on a couple of desktops to test it. I
can open up the main "switchboard" from more than one machine, but when
I try to open up my primary data-entry form, whichever machine opens it
second will just freeze up until the first closes the form. No warning
about anything being locked - it just sits there with the hourglass.

I'm running back and forth between rooms, so that is what appears to be
happening. I can't actually see both machines simultaneously.

I'm logged in as myself on one machine, and a fellow worker on the
other.

I must be missing something.

P.S. I'm posting a related question about security issues.

 

[Vince LaPointe]

Make sure your back-end database on the server is set to Shared access by
default. Also make sure user/group accounts don't have permissions to open
the back-end database in Exclusive mode. Also check the permissions your
users have on the folder where you located the back-end. User must have
read/write/create/delete permissions in order for Access to manage the record
locking files.

Vince

 

[Redbeard]

Can I assume that I'll find those settings in the Tools menu somewhere?
I kind of got this task by default since I'm the only person in my
department that knows anything about Access or programming. But I'm
out of my league.

 

[Redbeard]

I'm back at work where I can check the settings that you referred to.

Make sure your back-end database on the server is set to Shared access by
default.

Yes, it is.

Also make sure user/group accounts don't have permissions to open
the back-end database in Exclusive mode.

I haven't set up any user/group accounts. I was under the impression
that I didn't need to.

Also check the permissions your
users have on the folder where you located the back-end. User must have
read/write/create/delete permissions in order for Access to manage the record
locking files.

I don't control this, but everyone who would use this database should
have these permissions. I know for a fact that the users who let me
use their machine to test it do, so that can't be the problem.

I appreciate your help. Is there anything else that might cause this
problem.

I'm using Access 2000, but have the option to move up to 2003. Would
that help?