How do mutliple users open the same XP database?

[M Skabialka]

My users absolutely insist that my Access 2002 database be only one file,
not FE/BE and they want to simultaneously open it on the server. It's a
very simple database, where users look up information about document
numbers. Mostly no-one will be changing data.

My problem is that after one person opens the database, no-one else can - it
is locked out.

These people are afraid that if a change is made to the forms or reports and
they all have a copy on their machines, someone will miss out on the
changes. There is no way to change their minds.

So how do I get around this so that they can all look to their hearts
content?

Please save my sanity!
Thanks,
Mich

 

[Kevin3NF]

I would force the FE/BE issue by pointing out that if one of them opens it,
and then loses power to their machine, the data could be corrupted forever.

Resolve the FE changes issue by implementing Tony Toews AutoFEUpdater:
http://www.granite.ab.ca/access/autofe.htm


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[M Skabialka]

I have pointed this out to them - they say it is backed up nightly.

Isn't there a command line switch or something which will alow them to all
open it?

Mich

 

[Kevin3NF]

Have you set it to default to shared?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Rick Brandt]

Have you set it to default to shared?

That option setting is for the Access installation on each user's PC. It's
not a setting that "follows the file".

 

[Kevin3NF]

Thanks for clarifying that for me...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[M Skabialka]

I can't find that option - where is it? What is available on Access 2000
also?

Thanks,
Mich

 

[Douglas J. Steele]

I believe it's under Tools | Options, on the Advanced tab, for all versions.