Importing from Access 2003

[MSalty]

Hi,
I am trying to import a database into InfoPath from access. My question is
can I make each record in access create a different view in InfoPath. Say I
have 5 people with demographics such as DOB, Address and so on. I want each
person to have a different view or page in InfoPath. How hard would this be?

Any help would be great.

 

[Clay Fox]

There are many ways to architect what you are proposing.

In my opinion it is best to leave the data in Access or even better SQL and
then use InfoPath view and update the information. Then you have one form
which you can use to browse through each record. For an example check out
the Database Accelerator at http://www.qdabra.com

Otherwise you could have a form for each record and all of the data would be
in indivdual forms.

You could have one form that contained 5 sets of data and you could have a
view for each, but I am not sure why you would need to since you can create a
form view and then just have the data within the fields change. The issue
would be as more was entered it would become unwieldy.

Hope this helps
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[MSalty]

Thanks Clay for your help.

There are many ways to architect what you are proposing.

In my opinion it is best to leave the data in Access or even better SQL and
then use InfoPath view and update the information. Then you have one form
which you can use to browse through each record. For an example check out
the Database Accelerator at http://www.qdabra.com

Otherwise you could have a form for each record and all of the data would be
in indivdual forms.

You could have one form that contained 5 sets of data and you could have a
view for each, but I am not sure why you would need to since you can create a
form view and then just have the data within the fields change. The issue
would be as more was entered it would become unwieldy.

Hope this helps
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[BobCh]

Depends on what you want to do with the forms. For example, if you
host the forms on Sharepoint v3 you can Utilize the WorkFlow
capabilities, which provide some great added utility.

Also, housing the forms in sharepoint allows for some additional
collaboration.