I've been searching and searching and cannot find an answer.
I've an Access database on my c: drive with two tables (related).
1) I created a form on my c: and it worked fine, I moved the data and the form to a new laptop and it works fine. (different user paths)
2) I moved the database and form to a shared drive (y: at work) and it stopped working,
3) I searched and found out you cannot move an infopath form and change the publish location once created.
I remade he infopath design form direct on my companies Y drive,
I cannot publish this form at all. It keeps failing to read the database. In preview, it works fine.
In all scenarios, if I go into design and preview, it will read from the access database and return all the queried fields but I cannot open the form as a Form (only in design mode) to submit data.
I've exhausted Google and these forums and cannot find an answer that doesn't relate to sharepoint. I am simply using an access database with two tables and trying to allow my colleagues to update the database.
The error message I get is decipherable.
Can anyone help - please?!?!
