Integration question

[dave]

Hello -

Ive got a backoffice application that uses VB.NET to hit an Access
database. I've also got a website on a remote webserver hosted by ISP
that uses ASP.NET to hit a separtate Access DB on the webserver.

What is the best way to get data from my webserver DB into my
backoffice system? Note, I only have FTP access to the webserver.

Thanks,
Dave

 

[Joe Fallon]

I heard one of the MVPs mention that they use a little trick when they open
an mdb using a special shortcut or program. Essentially, they make a copy of
the mdb and store it on a network share so that it is "self backing up".
If you could do something similar, you would drop the file on your ftp site
and pick it up at your leisure.
Once a day or so.

Then link to it and import the data.