P
Paul Ponzelli
We have a number of split databases (Access 2002) on our network, where the
users have a copy of the front end on their local drives, linked to tables
in the back end on a network server. The front ends are *.mde files, and
the F11 key is disabled so they can't open the database window and view the
tables directly. However, they can open the tables directly by opening the
back end mdb file on the network drive.
We're running the Windows 2003 operating system on our network and Windows
XP on our desktops. I've experimented with preventing direct access to the
back end database files by restricting user access at the OS level.
However, Access 2002 reads network permissions, so if someone doesn't have
permissions into the back end at OS level, they can't open a linked
connection to the table from the front end, which is of course necessary.
I would like to avoid working with user and group security in Access, as I
have read and been told that it's very complex. One source described it as
ranging from labyrinthine to inscrutable. Is there a relatively simple way
to restrict direct access to the back end for all (but administrative)
users, and still retain full permissions through the linked connections in
the front end?
Thank in advance,
Paul
users have a copy of the front end on their local drives, linked to tables
in the back end on a network server. The front ends are *.mde files, and
the F11 key is disabled so they can't open the database window and view the
tables directly. However, they can open the tables directly by opening the
back end mdb file on the network drive.
We're running the Windows 2003 operating system on our network and Windows
XP on our desktops. I've experimented with preventing direct access to the
back end database files by restricting user access at the OS level.
However, Access 2002 reads network permissions, so if someone doesn't have
permissions into the back end at OS level, they can't open a linked
connection to the table from the front end, which is of course necessary.
I would like to avoid working with user and group security in Access, as I
have read and been told that it's very complex. One source described it as
ranging from labyrinthine to inscrutable. Is there a relatively simple way
to restrict direct access to the back end for all (but administrative)
users, and still retain full permissions through the linked connections in
the front end?
Thank in advance,
Paul