Databases and the Internet

[LadyDi]

Would it be possible to have a database table housed on an intranet site?

I would like to set up an Adobe form, so that it will automatically submit data in an ftp format to a database. However, I'm not sure if that is possible. I know that in order to even be able to test it, I will have to have a table housed on an intranet site. Ideally, what I would like to happen is, when a salesman submits a form to the order entry group, the ftp data will automatically be sent to the database. The order entry group would then go into the front end of the same database, find the submitted information and add a little more information (not included on the form). Does anyone know if this is possible? Will Access accept ftp data - I know Excel will? If Access will accept the data, I know I can set the form up to send it.

Any assistance you can provide would be greatly appreciated.

 

[PRMiller]

Tried to post a link, but I'm too new of a user. Do a Google search for "ftp data to microsoft access" and you should see an MSDN forum post titled "connect ms access database on a ftp location."

This did catch my eye:

Paul P Clement IV:

The Access database engine (or Jet) cannot connect to an Access database unless the Data Source is accessible via a file path. That means the file path in the connection string should start with a drive letter (physical drive or mapped drive) or be represented as a UNC path to a network resource (e.g. \\Servername\Sharename\folder\filename.mdb).

So unless the database location on the FTP server can be representing using a drive letter or UNC path on the network, the Access database engine will not be able to connect to the database file directly.