Submit Status Not Allowed!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jean - 29 Mar 2007 18:26 GMT

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!

Reply to this Message

S.Y.M. Wong-A-Ton - 30 Mar 2007 10:32 GMT

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.
---
S.Y.M. Wong-A-Ton

> 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
[quoted text clipped - 9 lines]
>
> Thanks a lot!

Reply to this Message