Sharing Access on SBS 2003

[gavin]

I was wondering if anybody has any experience putting an
Access database on an SBS 2003 server and running it from
clients. How does it behave? Are the changes dynamic
among the clients and server or does everything have to be
done on the server?

I know about making the file open in 'shared' mode, but
even then, I'm still having problems using the file by
multiple users, how far down/up do the file permissions
need to be set and what do they need to be set to? Right
now, the users have full control of the folder that the
database is in, but I still get the "this file can't be
opened - it's being used by another person" runaround.

Anybody? Help an Access newbie?


..

 

[Eric Butts [MSFT]]

Hi Gavin,

Is it just a matter of the folder inherting the permissions of the parent
folder? Example:

\Parent Folder (Read-Only)
\Child Folder (Full Control)

If the Child Folder is inheriting the Parent Folder permissions then the
effective permissions are (Read-Only)

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "gavin" <[email protected]>
| Sender: "gavin" <[email protected]>
| Subject: Sharing Access on SBS 2003
| Date: Fri, 9 Jul 2004 12:35:43 -0700
| Lines: 20
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcRl6+yqOhib1RXeR/ux6PuY81BSFA==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.setupconfig:30625
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| I was wondering if anybody has any experience putting an
| Access database on an SBS 2003 server and running it from
| clients. How does it behave? Are the changes dynamic
| among the clients and server or does everything have to be
| done on the server?
|
| I know about making the file open in 'shared' mode, but
| even then, I'm still having problems using the file by
| multiple users, how far down/up do the file permissions
| need to be set and what do they need to be set to? Right
| now, the users have full control of the folder that the
| database is in, but I still get the "this file can't be
| opened - it's being used by another person" runaround.
|
| Anybody? Help an Access newbie?
|
|
| .
|
|
|