Re: Submitting form writes to Access DB for Some Users... not others!

Hilary Stoupa — Wed, 10 Jun 2009 21:55:12 GMT

Have you had one of your 'submit successful' users log onto CP's machine and try to submit?

Submitting form writes to Access DB for Some Users... not others!

rzimmer — Wed, 10 Jun 2009 21:40:12 GMT

We are developing a tool for tracking change control that uses InfoPath forms with fairly complex rules, submitting to a few form libraries as well as writing to an Access DB (which will be transitioned to SQL Server.)

We are experiencing an inconsistent issue that has me stumped.

Some users are able to write to the DB and some are not.

None are getting error messages about this.

The best control group for the issue are three test users, CP, CW and MA. They all have the same permissions to the same sharepoint areas, including the site's Shared Documents, where the db currently sits. CW and MA are able to submit, and data is saved to form libraries and the db as expected. When CP submits, everything performs as expected EXCEPT nothing is written to the db.

No error or warning is given related to this, her submissions just don't write to the db but an autonumber Record ID is recorded on the form, what would be the next record in the db! (and she can read data from queries on the db in other forms)

One other test user so far has the same issue as CP.

... There are no workgroups or security built into the DB itself.... IE setting have been checked for accessing data across domains.

Thanks in advance for your help.

SQL Database Integration

Re: Submitting form writes to Access DB for Some Users... not others!

Submitting form writes to Access DB for Some Users... not others!