One of the errors I got was from the [Security Control Id setup] dialog at design time.
***The error read: Unable to create record in security table
I received this error when I clicked on the Generate Control Id button.
Since this is at design time,how can I trace it?
All my data is Oracle
the security table was setup following the schema in the documentation.
>Clay,
>
>>I got the same error message. Since I couldn't get the 'generate controlid' button to work, the UserSecurity table has no records, could this be part of the problem?
>
>You don't need records in this table to generate a ControlID...records get added to this table when you specify a security setting for a specific user.
>
>If you take your original error message at face value:
>
>"Parameter[0] '@USERFK' has no default value."
>
>Have you set a breakpoint to determine what the value of the userPK is? Is it null? I recommend stepping through the code to determine what's going on.
>
>Regards,
--------------------------
Clay Angelly
cangelly@ie-inc.comNever argue with an idiot. They drag you down to their level and beat you with experience.