Workgroup info file

[Gogila]

There is the question:

I have established a cost
control system in Store Development using Access.

Essentially I have two .mdb's, one is a back end
containing data
("STOREDEV_BE.mdb") , (not expected to be accessed
directly by users) and
the other is a front end linked to the back end tables,
accessible to users
("STOREDEV.mdb") . The properties of the file in Netware
are sharable,
transactional, archive, NOT read-only.

I want to provide security on the front end file, and
have established an
mdw file ("STOREDEV.mdw") , located in the same LAN
directory as the mdb's,
using the Access wizard. This works fine for me (I am
using Access).

However, my users are using Access Runtime , and using a
shortcut with the command
line :
S:\Storedev\_Database\STOREDEV.mdb /wrkgrp
S:
\Storedev\_Database\STOREDEV.mdw
they receive an error message
"You do not have the necessary permissions to
use the 'S:
\storedev\_database\STOREDEV.mdb' object".

I have tried setting up users within the .mdw with the
same names as their
ID on the LAN, and it doesn't make any difference;

Can you discuss / throw any light on why users can't
access the mdb???

That's it.
Thanks a lot.
G

 

[Peter Russell]

Access users must have full permissions on the Folders where the mdb files
reside. Access needs to create/delete files according to functions being
used. For example, ldb files must be created, modified and deleted.
So file-level permissions are insufficient.

Regards

Peter Russell

 

[Nancy Lytle]

Why not have the FE on each users machine using an AutoFEUpdater?
NLytle

 

[Jack MacDonald]

I always use a different name for the MDW file than for the MDB. See
the website in my signature for additional info.

There is the question:

I have established a cost
control system in Store Development using Access.

Essentially I have two .mdb's, one is a back end
containing data
("STOREDEV_BE.mdb") , (not expected to be accessed
directly by users) and
the other is a front end linked to the back end tables,
accessible to users
("STOREDEV.mdb") . The properties of the file in Netware
are sharable,
transactional, archive, NOT read-only.

I want to provide security on the front end file, and
have established an
mdw file ("STOREDEV.mdw") , located in the same LAN
directory as the mdb's,
using the Access wizard. This works fine for me (I am
using Access).

However, my users are using Access Runtime , and using a
shortcut with the command
line :
S:\Storedev\_Database\STOREDEV.mdb /wrkgrp
S:
\Storedev\_Database\STOREDEV.mdw
they receive an error message
"You do not have the necessary permissions to
use the 'S:
\storedev\_database\STOREDEV.mdb' object".

I have tried setting up users within the .mdw with the
same names as their
ID on the LAN, and it doesn't make any difference;

Can you discuss / throw any light on why users can't
access the mdb???

That's it.
Thanks a lot.
G

=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd