InfoPath Dev

Right you are. Maybe you can answer another question.  I was thinking of using SQL Server application security but when I try to send the command to start using the application role I get a security error.  It won't let me send commands to SQL Server - except the InfoPath connections that are used. My other idea was to set up a ...

I am making a form and I add a view to the SQL Server 2000 database and it doesn't show up when I try to make an InfoPath 2007 connection.  It shows the 2 default views made when the database was made and it shows the tables but any views I add do NOT show up.  I've tried closing InfoPath and opening it and looking with the same ...

 As far as I can tell it does a complete insert of all the fields I ask it to.  Some are null but I left them that way.  I have tried it different ways and the one time it did work I think I did fill in all fields, but I haven't been able to get it to work again all fields or no. Thanks  

I am appending records to an SQL Server 2000 database using InfoPath 2007.  I made a trigger on the table the form is based on but when I append a new record the trigger never fires.  The trigger works fine if I append a new record using Query Analyzer. I first assumed it just would not work due to some limitation of InfoPath but ...