[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

ODBC questions - Infopath - MsAccess Purchase ORder project

Stav

8/20/2007 10:14:00 PM

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