Submit Status Not Allowed!

[Jean]

Hi, I am new to InfoPath, i think it is a great way to update and add new
records to the Acces Database. But I am having a hard time connecting
InfoPath to my Access database.

The Submit Status is not allowed because the table doesn t have a primary
index, unique constant or unique index. I do have an index but duplicates
allowed, so seems i have to have a primary key, any way to have the Submit
Status Enabled without having a primary key in the access table?

Also, I have a Memo type field and I really need it to be there, and it is
not supported in InfoPath Any solution?

Thanks a lot!

 

[S.Y.M. Wong-A-Ton]

Unfortunately, with duplicates allowed, you won't be able to submit to a
database using a database bound InfoPath form; you need to use a primary key,
unique constraint, or unique index.

Regarding submitting memo fields, there have been several posts on the
topic; you can do a search on "Memo" to find the posts. But the general
consensus is that you can work around the issue by using a web service. By
the way, if you use a web service to submit to your database, you can work
around the issue of uniqueness too.