Database system architecture question

[dave]

Hello All -

I've got what is probably a very common situation, so Im looking for
input on best practices here.

I have a established Access database that our business uses as a
backoffice system, i.e. it is on an internal fileserver, behind our
firewall. We have various VB and ASP applications that utilize this
data.

We are building a job submission area on our website. Ultimately, the
data submitted on the website needs to go into this existing database.
The site is hosted by a third party vendor. The data will initially
be dumped into an Access DB on our webserver. I am looking for advice
on the best way to transfer this data back to our existing system.
Seems like there are potentially many ways to accomplish this??? XML,
table linking, FTP, replication, ODBC from a backoffice app, etc.

Any experiences are greatly appreciated.

Dave

 

[Arvin Meyer]

We use asp pages to write directly to the database through a firewalled
corporate intranet. If you need to maintain security, I'd suggest perhaps
using a separate database and appending the records once a day (or more
often if necessary) then either deleting them from the temp database or
marking them as "having been processed".
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access