Great form in Access... can I import into Infopath?

[Wendy]

I have created a wonderful Access database that records issues for my
company. I was just informed that I would be keeping records and creating
reports for all areas of our company now (not just mine). This is a national
organization. It is not feasible for me to train someone in each location so
I thought that I could make a form that relates to my database that they
could all fill out that would be perfect. They could fill the form out... it
would get automatically entered into the database and they would never even
have access to my database. My problem lies in trying to link the
information. I have a wonderful form that I have created in Access that I use
for my own entries. Is there a way to extract that form into Infopath? Also
when I try to do this manually it won't allow me to pull from the database my
tables that are used for validation rules. Will I need to do this manually?

 

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

To my knowledge, you cannot import an Access form into InfoPath, but will
have to recreate it manually yourself (use "New from Data Connection" when
creating your form and bind it to your database).

 

[Wendy]

Ok I just have one more question about this project... when I create a form
using "New from Data Connection" I keep getting an error saying it cannot
read some of my tables in Access or that they are unconnected. These are the
tables that I use for my pull down menus that just contain a list. Will I
need to enter these in manually?

 

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

Is there security of any kind on the database? It is kind of a strange
message to receive.

You can bind the form to one table (using New from Data Connection) and if
you need to get data from other tables to fill drop-down list boxes on the
form, you can create secondary data sources for each one of those "list"
tables and bind the drop-downs to the secondary data sources. Not sure if
this answers your question?