|
Home > Archive > MS Access Multiuser > May 2005 > sharing an XP Pro folder over a peer-to-peer network
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sharing an XP Pro folder over a peer-to-peer network
|
|
|
| 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
| |
| Douglas J. Steele 2005-05-20, 8:25 pm |
| 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.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Rick" < rfidler2004spam@eart
hlink.net> wrote in message
news:OjBO%238VXFHA.1508@tk2msftngp13.phx.gbl...
>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
>
>
>
>
| |
|
| The mdb file was set to compact on close.
That was the problem.
Thanks Doug
"Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
news:e$QWTFYXFHA.3280@TK2MSFTNGP09.phx.gbl...
> 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.
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Rick" < rfidler2004spam@eart
hlink.net> wrote in message
> news:OjBO%238VXFHA.1508@tk2msftngp13.phx.gbl...
>
>
|
|
|
|
|