Unfortunately, FTP is a system in which you TRANSFER a WHOLE file.
Thus, you can grab a word, or excel file via ftp, but in fact the WHOLE file
is transferred to the pc, changes are made, and then you can ftp it back.
The problem with ms-access, is that you can also do this, but it means that
the whole FILE is transfer to your pc, edits done, and then you would have
to transfer the whole file back to the fpt site (this would thus only allow
one user at a time, and of course the risk of one user updating, or
overwriting the file would make this not really workable).
So, FTP lets you transfer a file, but does not let you "OPEN" a file for
read, and writing PARTS OF THE file, which ms-access needs to be able to do.
So, you need a to be able to open the mdb file, and thus you need a network
system that allows you to browse, and then open the file like any regular
windows file. FTP supports none of the windows file systems and the reading
and writing of files. So, FTP is JUST a file transfer system.
You can most certainly place the data part in a server on your lan, and then
place the front ends (application part) on each workstation,a and link to
that back end. This works, and is normally how you setup ms-access to work
in multi-user situations.
However, if you are talking about a server, and wan, then you need to read
the following:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html