By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,536 Members | 2,165 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,536 IT Pros & Developers. It's quick & easy.

Help Sharing a database

P: n/a
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.

Jul 26 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a

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?

Jul 26 '06 #2

P: n/a
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?


Jul 26 '06 #3

P: n/a
did you split the front and back ends and put the fronts on each
machine?

Jul 26 '06 #4

P: n/a
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?


Jul 26 '06 #5

P: n/a
"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
Jul 26 '06 #6

P: n/a
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.
Jul 26 '06 #7

P: n/a
"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/
Jul 26 '06 #8

P: n/a
"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
Jul 27 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.