I started a purchase order project that will allow a few employees to access 
a purchase order over the network.  They will each be running infopath as 
their client.   Each employee also has MS Access 2003 or 2007 installed on 
their PC's.

I'm new at INFOPATH but I easily created a purchase order form on my own 
development PC called c:\tgs\docs\purchase_orders\TGS_PurchaseOrder4.xsn. The 
form I created has one field that is bound to an MS Access database table 
called c:\tgs\docs\vendors\TGS_vendors.mdb.

Recently my develoment machine crashed and I had to get the 
TGS_PurchaOrder.xsn and TGS_vendors.mdb files back from a computer over the 
network to which I make a backup copy of all my files every day.

ON the new computer, things would not work however.  I created a new ODBC 
connector (System DSN) called VendorsTBL which is the same name as the old 
one, yet infopath would complain with the following long error message:

"InfoPath cannot create a new, blank form.
InfoPath cannot open the form. To fix this problem, contact your system 
administrator.  

Form template: file:///c:\tgs\docs\inventory\TGSPurchaseOrder4.xsn
The form template is trying to access files and settings on your computer. 
InfoPath cannot grant access to these files and settings because the form 
template is not fully trusted. For a form to run with full trust, it must be 
installed or digitally signed with a certificate." 

The path of the Access Database file is:
c:\tgs\docs\Vendors\TGS_Vendors.mdb  ... There's an associated *.ldb file as 
well.
I noticed that I put a file called  TGS_Vendors.dsn with the following 
contents:

C:\tgs\docs\Vendors>type TGS_Vendors.dsn
[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=C:\tgs\Vendors
DBQ=C:\tgs\Vendors\TGS_Vendors.mdb

It is possible that in the previous version (the machine that crashed) I had 
used a file DSN, not a System DSN.  One difference from the old system, is 
that I recreated the directory structure differently since I stored the files 
under c:\tgs\docs\vendors and c:\tgs\docs\purchase_orders ...  not on 
c:\tgs\vendors and c:\tgs\purchase_orders as before.

How do I go about debugging this problem?  I already put an incident through 
the phone support but I was told InfoPath doesn't have a wait queue, but 
instead they only offer call-back phone support!  This is disconcerting to 
say the least.  

Do you recommend I use a web-based approach instead of the infopath-msaccess 
one?  If so, is there an easy way to translate the infopath form to a web 
form, if such thing exists?

My goal was to put the TGS_Vendors.mdb and TGS_PurchaseOrder.xsn files 
somewhere on a file server called \\ibackup2\ and have any user access the 
infopath form from there.  Is this possible? How do I go about doing it 
without getting mired with permissions/rights issues? If you can't directly 
tell me what to do step-by-step, could you at least point me to reading or 
implementation hints I'd appreciate it.

Thanks!


Stav