G
GG
I started an INFOPATH purchase order data entry project that will allow a
few employees to access
a purchase order form 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 retrieve 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:
---------------Start of error message quote:
"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."
---------------End of error message quote
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 in the old, crashed system I had 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. I subsequently loaded
the form in
design mode and created the system ODBC connector to the access database
TGS_Vendors.mdb
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 at \\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
few employees to access
a purchase order form 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 retrieve 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:
---------------Start of error message quote:
"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."
---------------End of error message quote
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 in the old, crashed system I had 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. I subsequently loaded
the form in
design mode and created the system ODBC connector to the access database
TGS_Vendors.mdb
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 at \\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