Getting data from web database , putting data into the web db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I have this access database on the web that is populated by the client. I want to use the information for mail merges into word docs. The problem is the only way I see I can get the information is by publishing the database from my remote to local. This is not a problem, but what happens when I need to change the status of an account or put in notes? If I publish from my local to the remote site, won't the remote database lose any new information clients have put in?

What is the solution? Thanks.
 
One way I know:
Write VBA code that sends and retrieves http request from the website
database to your mirrored tables in your database. The code on the website
is written in VBScript (Active Server Pages). Access has an Active X control
called MSInet.ocx. It is not the ideal solution, but it does work and I have
two courier companies that use it to place pickup/delivery orders via the
web.

Tam said:
Okay, I have this access database on the web that is populated by the
Click to expand...
client. I want to use the information for mail merges into word docs. The
problem is the only way I see I can get the information is by publishing the
database from my remote to local. This is not a problem, but what happens
when I need to change the status of an account or put in notes? If I
publish from my local to the remote site, won't the remote database lose any
new information clients have put in?
 
Back
Top