J
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?
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?