sharing an XP Pro folder over a peer-to-peer network

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 20 May 2005 18:13 GMT

I am sharing an XP Pro folder over a peer-to-peer network.
I added user to the XP Pro computer so they could login over the network and
access the shared folder. When user login from network computers and run an
MS Access program
no problems occur. But say John uses the XP Pro computer to run an MS Access
program
after he exits the program under file properties/security all user are
removed except John and administrators. So no one else can run the MS
Access program until I right click and add the users back under security.

Does anyone one have any ideas ?
Ricky

Reply to this Message

Douglas J. Steele - 20 May 2005 22:17 GMT

Does everyone use the same database? That's rarely a good idea: the database
should be split into a front-end (containing the queries, forms, reports,
macros and modules), linked to a back-end (containing the tables). Each user
should have his/her own copy of the front end, preferably on their hard
drive: only the back-end should be in the shared folder.

By any chance do you have the database set to compact on close? It's
possible that when John compacts the database, the permissions are being
changed.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I am sharing an XP Pro folder over a peer-to-peer network.
> I added user to the XP Pro computer so they could login over the network
[quoted text clipped - 8 lines]
> Does anyone one have any ideas ?
> Ricky

Reply to this Message

Rick - 24 May 2005 15:49 GMT

The mdb file was set to compact on close.
That was the problem.
Thanks Doug

> Does everyone use the same database? That's rarely a good idea: the
> database should be split into a front-end (containing the queries, forms,
[quoted text clipped - 19 lines]
>> Does anyone one have any ideas ?
>> Ricky

Reply to this Message