Help - Second posting

[Jimmy Youngblood]

I have an application that has been split into an FE and
BE, both Access XP. I have secured the backend and ant
the following to happen...
1. I have left an Admin user with no password on the
backend but with read only priviledges in an effort to
allow people to attach to the data with read only
priviledges. This works
2. I have a series of users and groups that have full
data priviledges/full database and I need to grant the FE
the full data priviledges at startup
3. I dynamically reattach my tables from the BE in my
autoexec (in case the files get moved)

My problem is that I need my front end to use my
application's mdw without making my user join that
workgroup and without making them logon. I don't want to
use the shortcut method to join the workgroup as this
would violate my security. I need the code (probably in
my autoexec) to create the application workspace for all
recordsets during my open session to allow my FE
operations full data rights using my User that has these
rights.

Any ideas?
..

 

[Jack MacDonald]

I have an application that has been split into an FE and
BE, both Access XP. I have secured the backend and ant
the following to happen...
1. I have left an Admin user with no password on the
backend but with read only priviledges in an effort to
allow people to attach to the data with read only
priviledges. This works
2. I have a series of users and groups that have full
data priviledges/full database and I need to grant the FE
the full data priviledges at startup
3. I dynamically reattach my tables from the BE in my
autoexec (in case the files get moved)

My problem is that I need my front end to use my
application's mdw without making my user join that
workgroup and without making them logon. I don't want to
use the shortcut method to join the workgroup as this
would violate my security. I need the code (probably in

If the everyday users just open Access using their default MDW, they
will be logged in as Admin, thus able to use your application because
of the permissions you have provided on the BE. Only the special users
would require a shortcut to join the secure MDW.

The Admin user also requires permissions in the FE so the everyday
users can open and run that database.

The document in the website in my signature my help.

my autoexec) to create the application workspace for all
recordsets during my open session to allow my FE
operations full data rights using my User that has these
rights.

Any ideas?
.

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