Publishing on a Shared Network

A

abc

I'm using Infopath SP1 and connect to an access database.

My access database is connected from a shared network on my L:\drive.

I published my form into a folder on my L:\drive (same shared network).

I log into a different computer and map network drive into a different
LETTER drive (let's say Z:\drive) but on the SAME shared network.. and
my form will not open because its calling for the database to be on the
L:\ drive.

How can I change my database to pull from a non-specific letter drive?

Please help! I have about 150 users and cannot expect them to have the
Letter 'L' available for them to map to!
 
J

Jay W

You should be able to connect to the database using a UNC path
(\\server\folder\database.mdb) which would eliminate your issue.

HTH,

Jay
 
F

Franck Dauché

Hi,

Your connection string is hard coded in your manifest.xsf file. As a
general rule, to avoid all these issues, you can build a Web Service between
your form and your DB. This way, you may even upgrade to SQL Server without
having to update your IP form.

Franck Dauché
 
A

abc

I understand what you mean.. but not sure how to do this.. when I'm
connecting a database.. it does not give me the option to use a UNC
path..??? I select my database from the shared network.. and it
automatically using L:\ drive???
 
F

Franck Dauché

Extract your source files from your xsn, edit the manifest.xsf with notepad.
Find and replace L:\ by \\server\...
Open your xsf in design mode and re-publish your xsn (overwritting your
existing one). You are done.
If you are using Managed Code behind, just recompile the form after manually
modifying the manifest.

Franck Dauché
 
F

Franck Dauché

Right-click on your form and open in design mode. Then, go to File \ Extract
Form Files. Make sure that you backup your file before! Editing manually
the manifest.xsf may be dangerous if you are not that familiar with InfoPath!

Franck Dauché
 
A

abc

THANK YOU.. it works! stupid me... just now figured out to go to File..
Extract Files..

THANK YOU!!!!!!!!!!!!!!!!!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active Content in this file is blocked issue 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Merging from an Excel file with graphics 1
prevent deletion of a workbook in a shared network drive 5
Will I be able to use InfoPath in this network scenario? 2
Problems Publishing to a Network 1
InfoPath Publishing - Best Practices? 0
Ok, a really simple one... 2

Top