I have a database (initially) empty, but with a table defined.  I want to
create a form that I need folks in my company (all over the world) to
complete and have this information update my database (MS Access , for now).

I have created a form, and published it to a sharepoint site, but it seems
that I am the only person that can query the DB through the form and/or
submit data.  Others in my company have tried it and get errors asking for
passwords, etc (I had set no security at all on the Access DB).

I think Infopath may be a kill way to gather tons of info, but man, if I
can't give them input folks a form and/or can't get what they submit back
into the DB, it is not much help.

I have looked at a number of books, but while they show you how the create a
form and link it to a DB (this works just fine, for me, personally), no one
else seems to be able to actually use it.  Also, none of the books seem to
address how to publish and distribute a form, and how to set up the related
forms and DBs to make it all work.  Any suggestions on a reference?  Any easy
pointers to "how to" guides to do this?

FYI, my DB is on a 'wide open" file share on MS Server 2003, if that has
anything to do with it.  

Many thanks!

Pat