Steve Kendrot
New member
- Local time
- Today, 22:47
- Joined
- Jan 16, 2004
- Messages
- 9
I have created a split database and implemented security
on both ends. In the FE, I gave all users in the NUTECREW group full permissions to tables. On the BE, I gave NUTECREW read permision on all tables and update,edit, insert, delete on several tables. The problem is when I log onto either the FE or the BE as a user, I am denied access and told to contact DB administrator to assign the appropriate permissions. So for grins, I assigned full permissions to all tables for NUTECREW and a user in that group still cannot open the tables (through forms) in the FE and I can't even get into the BE when logging on as a member of NUTECREW.
Everything works fine when I am logged in as the
administrator, whose permissions are defined by the group NUTEBOSS. AS LONG AS the tables are linked in the FE using standard drive mapping. However, if I link the tables in the FE using UNC, and log in as the administrator/owner, I can only view the forms as read only.
Can anyone shed any light on my problems? I've read and reread the Security FAQ and spent hours browsing past post here and on other forums and can't seem to get any headway.
__________________
Steve
on both ends. In the FE, I gave all users in the NUTECREW group full permissions to tables. On the BE, I gave NUTECREW read permision on all tables and update,edit, insert, delete on several tables. The problem is when I log onto either the FE or the BE as a user, I am denied access and told to contact DB administrator to assign the appropriate permissions. So for grins, I assigned full permissions to all tables for NUTECREW and a user in that group still cannot open the tables (through forms) in the FE and I can't even get into the BE when logging on as a member of NUTECREW.
Everything works fine when I am logged in as the
administrator, whose permissions are defined by the group NUTEBOSS. AS LONG AS the tables are linked in the FE using standard drive mapping. However, if I link the tables in the FE using UNC, and log in as the administrator/owner, I can only view the forms as read only.
Can anyone shed any light on my problems? I've read and reread the Security FAQ and spent hours browsing past post here and on other forums and can't seem to get any headway.
__________________
Steve
