Re: Creating a secure database on a network
- From: "Jeff Conrad" <jeffc@xxxxxxxxxxxxxxxxx>
- Date: Mon, 31 Oct 2005 22:51:52 -0800
"Secret Squirrel" wrote in message:
news:2B89A4B1-8290-4361-9081-E6A9173C2CC3@xxxxxxxxxxxxxxxx
Comments in-line....
> Before I run this test I have two questions..
>
> If I want to change a query or report down the road, how would I go about
> this if I put the FE on everyone's desktop? Will I have to change it on
> everyone's pc?
You would need to give each user a new FE file. Depending upon how often
you make changes and the number of users, this could be very easy or tedious.
MVP Tony Toews has a utility to handle this for you here:
http://www.granite.ab.ca/access/autofe.htm
I have not used it myself, but have heard very good things about it.
I know what you are thinking:
"Wouldn't it be easier just to have one file on the server for all the users to share?"
The answer is definitely NO because you will have FAR greater chances of
database corruption with users sharing the same file! All your hard work
would be lost. Do not stray towards the dark side.
> Also, can you give me an example of what the shortcut should be like?
At this point I have to ask:
"How are you opening the secured database on your machine?"
You should be opening it from a shortcut icon with the correct parameters.
If you are joined to the custom workgroup file at all times (which I suspect)
this is not really the way to go.
The shortcut syntax is generally like so:
"Path to MSACCESS.EXE here" "Path to database file here" /WRKGRP "Path to workgroup file here"
All of that would be on one line. You would need to modify for your needs such
as where Access has been installed and where you have your files. Now since
the workgroup file will be on the server you'll have something like so:
"Path to MSACCESS.EXE here" "Full path to FE on user's PC" /WRKGRP "Full path to MDW on server"
For the last part you can use UNC like so:
"\\ServerName\ShareName\Security.mdw"
(Just an example, you will need to modify)
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
.
- References:
- Re: Creating a secure database on a network
- From: Jeff Conrad
- Re: Creating a secure database on a network
- Prev by Date: Re: security with system.mdw
- Next by Date: Re: Access Security When called from .NET
- Previous by thread: Re: Creating a secure database on a network
- Next by thread: Re: Creating a secure database on a network
- Index(es):
Relevant Pages
|
