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.