Help Sharing a database

[Kissi Asiedu]

I have a database in a shared folder, however users with permission can only
access the database in read-only format. What have I done wrong? This is on
Win Xp Pro and Access 2003. Please help.

Thanks.

[pietlinden]

Kissi Asiedu wrote:

I have a database in a shared folder, however users with permission can only
access the database in read-only format. What have I done wrong? This is on
Win Xp Pro and Access 2003. Please help.

Thanks.

What rights do the users have on the folder containing the database?
Read only? Can they create files?

[Kissi Asiedu]

I have tried giving users full control but it still didn't work.
<pi********@hotmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...

>
Kissi Asiedu wrote:

>I have a database in a shared folder, however users with permission can
only
access the database in read-only format. What have I done wrong? This is
on
Win Xp Pro and Access 2003. Please help.

Thanks.

What rights do the users have on the folder containing the database?
Read only? Can they create files?

[pietlinden]

did you split the front and back ends and put the fronts on each
machine?

[Kissi Asiedu]

I am sorry, I don't know what that means. Could you break it down please? I
am new at this. Thanks.
<pi********@hotmail.comwrote in message
news:11*********************@75g2000cwc.googlegrou ps.com...

did you split the front and back ends and put the fronts on each
machine?

[Keith Wilby]

"Kissi Asiedu" <ki*******@aol.comwrote in message
news:i0*******************@fe14.usenetserver.com.. .

>I am sorry, I don't know what that means. Could you break it down please? I
am new at this. Thanks.
<pi********@hotmail.comwrote in message
news:11*********************@75g2000cwc.googlegrou ps.com...

>did you split the front and back ends and put the fronts on each
machine?

Search the help for "split database".

Regards,
Keith.
www.keithwilby.com

[ManningFan]

Right-click the database filename in Windows Explorer and go to
"Properties". Make sure the database isn't marked for Read-Only.

Kissi Asiedu wrote:

I have a database in a shared folder, however users with permission can only
access the database in read-only format. What have I done wrong? This is on
Win Xp Pro and Access 2003. Please help.

Thanks.

[David W. Fenton]

"Kissi Asiedu" <ki*******@aol.comwrote in
news:TH******************@fe59.usenetserver.com:

I have tried giving users full control but it still didn't work.

Are you giving full control in Jet security, through Access, or in
NTFS?

Where is the file stored? I recently encountered a situation where
an app was written to place the MDB in a folder in the programs
directory, which in WinXP is restricted to read-only. The machine
had the colossally stupid "simple file sharing" turned on, so there
was no way to change permissions on that folder. Once "simple file
sharing" was turned off, the permissions on the folder could be
changed, and then everything was OK.

Two points:

1. WinXP "simple file sharing" is bloody stupid and useless
(especially since it uses the EVERYONE group to allow literally
EVERYONE to access data in its public shares).

2. creators of Access applications should *never* place their MDB
files in folders under the programs folder.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Keith Wilby]

"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...

>
bloody stupid

Hey, that's an English expression! ;-)

>
2. creators of Access applications should *never* place their MDB
files in folders under the programs folder.

At my place of work all of the C drive is locked down except for c:\Temp and
the user's profile folders so I have to put my FEs in one of those.

Keith.
www.keithwilby.com