Cant share a database?

[Douglas J Steele]

Check the permissions on the Share, not just the folder.

Sometimes the Share permission will downgrade the folder permission.

 

[JethroUK©]

I cant share a database with another user - the database is split and both
ends are in the one network folder

Both users have windows read/write permission on the folder and both parts
(front & back) of the database are set to share (left at default)

but when one user opens the front end the other user it locks the other user
out

any thoughts?

 

[Dirk Goldgar]

I cant share a database with another user - the database is split and
both ends are in the one network folder

Both users have windows read/write permission on the folder and both
parts (front & back) of the database are set to share (left at
default)

but when one user opens the front end the other user it locks the
other user out

any thoughts?

Do both users have Create and Delete permissions as well?

 

[JethroUK©]

Where would i find share permissions (as opposed to folder permissions)?

Database permissions are 'Shared', 'No Locks'

 

[Douglas J Steele]

You'd have to look at the actual folder on the server.

Before you try doing that, though, can the users both create files in the
folder and then delete them?

 

[Roger Carlson]

Do you mean to use the database? Or are they both trying to create/edit
objects (ie forms, reports, etc.)?

If it's just using the database, Doug and Dick have asked the right
questions. If it's a matter of editing objects, with Access 2000 and
forward, only one person can edit objects at a time.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[JethroUK©]

i know all staff have read/write to the share folder but ill have to go
into work tomorrow and check for sure

although i would expect any issues with windows would prevent anyone using
it at all (as opposed to only preventing sharing)

 

[JethroUK©]

its only using it - in fact it's it's .mde so there is no design editing

 

[Douglas J. Steele]

They may have read/write, but if they can't create files in the folder,
they'll be unable to create the locking file (.ldb).

 

[Jeff Boyce]

Why is the front-end on your network? A more traditional design puts a copy
of the front-end on each PC, linked to the back-end on a server.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Daniel]

I don't know if I add more information here but I had the same problem with a
database I was testing. The users did not have write permissions to the
folder. When the permissions for the folder were changed, the problem
remained because the database apparently did not inherit the changed
permission from the folder automatically; you could check this as well.

Regards,
Daniel