How to connect InfoPath to Access db containing only linked tbls?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susie C - 05 Jun 2006 17:26 GMT

I wish to create an InfoPath form where the data source is an Access database
that contains only linked tables. If I create a local copy of the linked in
the Access database the link will work, but that table will not be current
whereas the linked tables always contain current data.

Reply to this Message

Madhuri Nishanker Rao - 06 Jun 2006 07:06 GMT

Hi
To access the current Access database you need to add database as data
connection to the InfoPath. To add database to your InfoPath you need to do
in the following way

1.    Open the form in design mode
2.    Go to Tools menu
3.    Select ‘Data Connections’
4.    Click on ‘Add’ button to add database

Signature

Madhuri Nishanker Rao

http://www.autonomysystems.com

> I wish to create an InfoPath form where the data source is an Access database
> that contains only linked tables. If I create a local copy of the linked in
> the Access database the link will work, but that table will not be current
> whereas the linked tables always contain current data.

Reply to this Message

Susie C - 08 Jun 2006 16:08 GMT

Thanks for answering - I can link to a database just fine, but the database
itself has linked tables. Infopath will only recognize local tables. Do you
know a way around this?

> Hi
> To access the current Access database you need to add database as data
[quoted text clipped - 10 lines]
> > the Access database the link will work, but that table will not be current
> > whereas the linked tables always contain current data.

Reply to this Message

Tim Larson - 29 Jun 2006 04:32 GMT

Susie, a workaround is to create a table as a query in access that includes
the fields of interest. Then from infopath you can link to that. It has
worked for me with the same problem.

Signature

Tim

> Thanks for answering - I can link to a database just fine, but the database
> itself has linked tables. Infopath will only recognize local tables. Do you
[quoted text clipped - 14 lines]
> > > the Access database the link will work, but that table will not be current
> > > whereas the linked tables always contain current data.

Reply to this Message