Re: Shared Folders snap-in...
From: Carrie Garth (cgarth@alpha1.net.INVALID)
Date: 03/19/03
- Next message: Mike: "Re: Prevent users from installing software"
- Previous message: Rick: ""DDE Server Window" -- why?"
- In reply to: Rajen: "Shared Folders snap-in..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Carrie Garth" <cgarth@alpha1.net.INVALID> Date: Wed, 19 Mar 2003 05:47:03 -0600
Hi Rajen,
Have you checked the help files included with your database program to see what it says
about sharing a database on a network?
For example, with Microsoft Access 2000 a simple solution is to use the command that
"Opens the specified Access database for exclusive access". That way, if someone else
has the database open you get a warning message saying the file is already in use and
you can't open the database. And if no one else has it open, it will open in Exclusive
mode and lock out everyone. For more information, search Microsoft Access 2000 Help for
the phrase in quotes.
Also for Microsoft Access 2000, there is a DLL available from Microsoft that will let
you see which people are using a specific database. For more information, see the
following FAQ Section 21. How can I tell who is logged on to my shared, networked
application?
Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions
2.0 through 2000
By Mary Chipman, Andy Baron, Chris Bell, Michael Kaplan, Paul Litwin, and Rudy Torrico
http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq%2Easp
BTW, if your database application is Microsoft Access: 1) You could try posting your
question in one of those forums. 2) You may want to research the Database Splitter
feature that splits the existing database between its data and its objects.
Carrie
> "Rajen" Sent: Monday, March 17, 2003 08:13 PM
> We have a database that needs to be viewed by the whole
> company, so for ease of access I have placed it on our
> server (Win2K) in a shared folder. Unfortunately every
> time the database author needs to make changes, he must
> ensure that no one is connected to it. This requires him
> calling and having me check with MMC to see who's
> connected. I would like to give him the ability to view
> the connections himself but keep him as a restricted
> user. All the documentation I have read says that one
> MUST be an admin or power user to view through MMC. Is
> there a way to create a user group that just has access
> to the Shared Folders snap-in? I have tried publishing
> the folder to Active Directory and delegating control
> with no luck.
>
> Any ideas would be greatly appreciated!
> Rajen
- Next message: Mike: "Re: Prevent users from installing software"
- Previous message: Rick: ""DDE Server Window" -- why?"
- In reply to: Rajen: "Shared Folders snap-in..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
