Access is denied to a datasource.

[Se3ker]

Hello.

I am trying to create a purchase order form, which stores the data entered
to an access database. Ive done extensive reading on the subject, yet i
cannot find anything which mentions this problem.

I think ive done everything correctly following some examples and tutorials,
ive bound all the necessary fields, added a submit action to a datasource
conneciton. Yet whatever i try ends up with:



InfoPath cannot connect to the data source.
Access is denied.
Access is denied.


What am i doing wrong? can someone help me please.

 

[Se3ker]

Managed to get it working.

Tools->Form Options->Security and Trust

Although i have another question:

How do i list all of my "Purchase orders" and add - delete or edit command
buttons - to them. so i can easily delete one from the list or edit it. For
the edit command id need the whole record to show and then resubmit. Is it
even possible?

 

[kenjpark]

I know this is an old post but just wanted to thank you for stopping
me from tearing my hair out.

Why isn't this mentioned anywhere in the MS How to.. guides??

For anyone wanting to do something similar try here:
http://office.microsoft.com/en-us/help/HA011199501033.aspx