submit to database

[monique]

I tried using Infopath and one table of Access database,
and I can easily submit the form's data into database.
However when I tried using SQL the option of submitting
into database wasn't there. It also happened when i use
more than one table in Access.
did i do something wrong there or it's just not possible
to submit into database with SQL or with database of more
than one table?

Thanks

Monique

 

[Steve van Dongen [MSFT]]

I tried using Infopath and one table of Access database,
and I can easily submit the form's data into database.
However when I tried using SQL the option of submitting
into database wasn't there. It also happened when i use
more than one table in Access.
did i do something wrong there or it's just not possible
to submit into database with SQL or with database of more
than one table?

The last pane of the datasource wizard tells you if and why the submit
behaviour is enabled.

Regards,
Steve

 

[Tom Curtin]

Just a thought.. This happended to me several times in working with datasets
for an end-user. I found that the MS Access tables lacked a key. Without a
key infopath can't do the submit of the update. Added an indexed key and
everything was great. My general rule is to always have keys, but sometimes
end user apps coming from Access 97 lack them.