Hello, Loyd

This message usually indicates that your PK value isn't getting sent to the table.

First, make sure the view being used to populate the security table is marked as sending your PK field and that the field is updatable.

Then make sure your DE is built correctly. Rebuild the DE if necessary.

Hope that helps,
---J

>I am trying to convert my app from local data to MS SQL. I have all of my user interface and data working properly but can not seem to figure out how to get the built in security to work properly.
>
>I can add a new user but when I try to assign them to a group it blows up with "unable to insert empty row into base tables..."
>
>The same happens when adding or changing the "rights" to a specific control.
>
>Any help would be greatly appreciated.