Problems submitting data to SQL Server

[Christoph]

I'm trying to set up a form that allows submission to a SQL Server
table. However, I cannot set it up so that it actually submits the form
to that table, which does have a primary key defined btw. The steps
I take are:

File -> Design a form -> New from Data Connection -> Database
(Microsoft SQL Server or Microsoft Office Access only) -> Select
Database -> Open my .odc file -> Select Table -> Finish

When I try to go to Tools -> Submitting forms, the option to submit
to a database isn't there. Why not? What am I doing wrong?
Should it not be there?

Chris

 

[Matthew Blain \(Serriform\)]

Go through the wizard again. One of the pages (I don't remember which off
the top of my head except it's really easy to miss) will have an error
message expaining that submit will be disabled and why.

--Matthew Blain
www.serriform.com