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