Form design incorporating access to a database

Last post 08-28-2009 04:24 PM by Hilary Stoupa. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

08-26-2009 09:11 PM

tighthead3
Joined on 08-27-2009
Posts 1

Form design incorporating access to a database

Reply Contact

I have tried a number of ways to resolve the following problem with no success. What I want to do is have a form that I can publish to a SharePoint collaboration site where part of the form is based on an Access database so that the data entered each time the form is completed is stored in the database table for use by another department. I can build and publish a form…...no problem. I can develop a form based on a database which does what I want it to do….no problem (except that some of the fields in the form require far greater than 255 characters and of course this is not possible) but what I can’t do is have an “ordinary” form part of which stores the data in Access. Help!!!!

08-28-2009 04:24 PM In reply to

Hilary Stoupa
Joined on 06-20-2008
Posts 13,297

Re: Form design incorporating access to a database

Mark as Not Answer Mark as Answer ...

Reply Contact

Hi:

So, if you aren't going to write custom code, if you want to submit to Access, you have to base your form off the database you intend to submit to. However, you can add additional 'ordinary' fields to the resulting data source (for information that you just want stored in the form). You can only add new fields to the very root of the data source, so in the Main Data Source (after having created your form by basing it off your Access DB) you can right click at the very top folder and then start adding other fields.

Hope that helps!

Hilary Stoupa

Page 1 of 1 (2 items)

InfoPath Dev