Security-Setup of a new form

[PatK]

I have a form published on a sharepoint site, I will call FormA. It has DB
connection to an MSAccess DB, AMDB.MDB (via ODBC) that resides on Server B
(different than the sharepoint server).

When I created the form, I had a "mapped" networked file drive, W: that is a
shared folder from Server B.

I asked a friend to test my form and tell me what happens. They were
getting errors that they could not find the W:\AMDB.MDB, so thus could not
update the form. Thus, I had her map W: to the same file share that I used,
and that worked. (I added her to a global group that has access to that
share).

However, in reality, I am going to send this form when we actually use it,
to about 1000 people in my company. I do not want to have to explain how to
map the W: drive to their systems (not to mention any subsequent issue if
they already have W: mapped elsewhere, and it is unchangeable).

Isn't there some way to map the connection to more of a UNC name, like
\\ServerB\filefolder and have that "built in" to the form, so I do not have
to have everyone map the W: Drive?

ALso, finally, does everyone that I want to fill in the form need to have
infopath installed? This is possible to do, but I would need to include
instructions for them to do so, and I am not sure I need this. Assume
so??????

Thanks for any help/guidance!

PatK

 

[Adam Harding]

Hi

As to your first question, you can indeed specify a UNC path to the database
that would solve your problem no 1

Second question; you users would indeed need infopath to be able to view and
use the form. Easiest instructions are to go into control panel, add/remove
programs, Microsoft Office Components and tick Infopath, then next, next out
of there.

That should help.

Cheers Adam

 

[PatK]

Thanks for the response, Adam! Hey, regarding problem #1, can you tell me
how to link to the UNC name? I thought I had, already, but apparantly not.
I already have the form created. Is there a way to drill in to a properties
setting somewhere, and change what must be a reference to the W: drive, to
the UNC name? Sorry...I have been using infopath for about 3 business days,
so sorry if this is a really obvious question/answer.....

Thanks again!

pat

 

[Adam Harding]

Okay

Go into tools and data connections

click your access db connection and click modify, click to change database,
and then type the name of the server and folder as follows;

\\server\folder1\folder2\folder3\MSAccess.mdb

Or browse, click network neighbourhood, entire network, find the domain the
server is in and browse onto the server and find the database. OK out of
there and you are done.

Cheers Adam

 

[PatK]

Thanks...I will give it a shot!!! (I assume this is done in forms design).
THanks!

Pat