Networking Woes

[Mel]

HELP! I am so confused...
I created a database, spent multiple weeks cleaning 25,000 records and
it works fantastic on my desktop.

I needed to share it with other users and so I split it using the
splitter wizard. I put the 'be' on the shared drive (everyone has
access to this drive and can basically destroy it if they like)

I put the 'fe' copy on each of their hard drives and only one of us can
access the data at a time.

We all can run reports but only one at a time can open the form that
accesses the main table.

There are no permissions set, it is just a basic database.
Options/Advanced tab is set to 'shared' and 'no locks', the user &
group permissions are all set to the default 'admin'.

I am at a loss, I have spent 2 days working with microsofts online help
and scouring this site but I can't figure it out.

Any help would be greatly appreciated...I'm getting bald.
Thanks,
Mel

 

[Joan Wild]

Users need more than just 'access' to the shared drive. All users need
create, read and write permissions (Windows permissions) on the folder where
the backend is.

 

[Mel]

Thanks for the quick reply. They do have access, I went to each of
their machines and created a txt file in notepad, then saved it to the
folder. They can open, delete, edit anything in any folder on this
drive.
Mel

 

[Joan Wild]

I can't think of anything else. Are you logging into these machines with
your username or their's?

 

[Nick Coe \(UK\)]

What Joan said

Plus log on to the server as an administrator and then right
click on the BE file in the shared folder. Select Security
and File Sharing if it's there and see what it's set to.
Also look for Permissions. What options you get depends
upon what op sys is running on the server. Make sure _each_
Windows user account accessing the BE has sufficient power
as Joan said.

Are any of the objects in your BE being opened in design
view? That will lock any Acc2000 and later mdb into single
user mode.

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In
Mel typed:

 

[Nick Coe \(UK\)]

Oh and make sure you don't have a corrupt locking file left
behind when ALL users are NOT using the BE. Look in the BE
folder for a file with the same name as the mdb but an ldb
suffix. Delete it when you are certain there's no one else
in the BE.

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In
Mel typed: