Security Question

[LW]

Hi there,

Our Access database has been on our company's public
drive, accessible to all to read, edit etc. Only one lady
updates this file every few days. We put this file onto
our Web Server, in order to extact information via our
Intranet and that worked fine with asp programming.
However, even though we have given the lady who updates
the file all permissions through the web server folder,
when she brings the file up at her station she gets a Read-
only message.

Only the administrator can bring the file up now and work
on it. From the Security tab within Access it appears I
can set up a workgroup, but the users don't come up as a
list like they do in Windows.

My question is, why did the database work on the public
drive and not on the web server? And do I have to now go
in and set permissions in order for this lady to update
it? I'm not sure how to do this within Access itself, or
if it is even necessary, since it wasn't necessary when
the file resided on the public drive.

The problem is, in order for the Intranet search form to
work the file HAS to be on the web server.

So we are between a rock and a hard place. Any suggestions?

Thanks in advance!

 

[TC]

First, some background information that you might or might not know.

An Access database (MDB) file has to be used in conjunction with a suitable
Workgroup Information File (MDW). If you do not use a suitable workgroup
file, the database might not be openable, or, you might not get the expected
permissions (read, write, edit, delete).

If you start the database from a shortcut, the shortcut can (but does not
have to) select a suitable workgroup file, by using a /wrkgrp switch in the
shortcut target. The selected workgroup file might be on the local PC, or a
sever, depending on the file path.

If the shortcut does not use that switch, or you start the database without
using a shortcut (eg. by double-clicking the database file), a default
workgroup file is used. That default is defined seperately for each PC where
Access runs.

So, when you move a database to a different PC, you have to consider whether
it is necessary to move the workgroup file, as well. This depends on how the
database is being started; where the workgroup file is at present; and which
files you are moving, where.

Does that help?

TC

 

[TC]

Further to my other post, if you copied the database via CD, remember that
when you restore a file from a CD, the destination file is marked "read
only". Right click the file, choose properties, and see if that attribute is
set. If so, un-set it!

HTH,
TC