473,323 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

How to sync local and web database?

I am wondering if their is a strategy or tool for syncing a local
database with a web-based database? Specifically I have an application
where orders are entered via a web form and the data emailed to my
client who processes the orders. I extract the order information and
update a local "order tracking" database. There are several order
processing steps. I want to update a web database to reflect the status
of the order as it flows through the local tracking application. I will
send an email to the "orderer" at the major steps, but my client wants
to have a web-based report shows the status of all orders for a company
that has pending orders. In other words a company will enter multiple
orders and will be able to track the status of the orders by signing on
to the web site. This status report gets its data from the
web-database.....which I must update from the local tracking database.
A pretty long winded explation which I hope mades sense. Has anyone
found a solution to this problem? Any reference or tools you can
suggest?

I am using MS Access mdb as the databases. Email client is MS Outlook.
Web is based on ASP.
Thanks for your responses, Jack

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
2 3065
Is the local tracking "application" something you can adjust?

For example, if the application were written in VB, I'd have an "update the
website" button that would call
http://theserver/updatedatabase.asp?ID=XXX&Status=XXX

and obviously updatedatabase.asp would Update the website's database.

Just one approach.


"Jack Crawford" <ja**@drofware.com> wrote in message
news:u5**************@TK2MSFTNGP10.phx.gbl...
I am wondering if their is a strategy or tool for syncing a local
database with a web-based database? Specifically I have an application
where orders are entered via a web form and the data emailed to my
client who processes the orders. I extract the order information and
update a local "order tracking" database. There are several order
processing steps. I want to update a web database to reflect the status
of the order as it flows through the local tracking application. I will
send an email to the "orderer" at the major steps, but my client wants
to have a web-based report shows the status of all orders for a company
that has pending orders. In other words a company will enter multiple
orders and will be able to track the status of the orders by signing on
to the web site. This status report gets its data from the
web-database.....which I must update from the local tracking database.
A pretty long winded explation which I hope mades sense. Has anyone
found a solution to this problem? Any reference or tools you can
suggest?

I am using MS Access mdb as the databases. Email client is MS Outlook.
Web is based on ASP.
Thanks for your responses, Jack

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

Tom, I have written the local tracking application in VBA as part of a
MS Access database, so I can "adjust it".

I was thinking about the approach you suggest. The question would be
how the updatedatabase.asp would function. Haven't given it enough
thought, but seems that most request would fall into a limited number of
"operations"?
1)add a record to a table
2)edit a field with/in a record
3)delete a record
4)other?

Seems like the asp code could have several possible forms:
a)Could be simply as sql executer? Send a sql string to be executed by
the asp code?
b) Could be a "transaction processor". Parameters would be the "Tran
Type" and the table and the datas.

Any comments and/or suggestions? Any articles or perhaps someone has
written a tool to do this? I will be working on the project over the
next few weeks, so any input would be appreciated.
Thanks, Jack
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jason Gyetko | last post by:
I have a software application with an Access front end and an Access backend to house the data. Recently I converted the backend to MySQL. The Access frontend works fine connecting to the MySQL...
0
by: Tony Fibannaci | last post by:
I have two db's. One on a local server, one on a remote server. Both are running MySQL 4.0. The remote is a production server that I run mysqldump on nightly to backup the prod data. The local...
1
by: Rob F. | last post by:
I have tried to set up log shipping for one of our databases - first time. Using EM I was able to create the job and maintenance plan sucessfully. I wasn't able to find any errors in any logs. ...
1
by: dave | last post by:
I am not sure where to ask this question but i was hoping somone could put me in the right direction. I have a pda (ipaq) that i would like to synchronize with my outlook. The data is stored...
5
by: Karl | last post by:
Hi C# experts, I am to C# and .NET. I am writing a database application using C# and Dataset. In Sql server, I have a Acount table which contains over 100,000 records. This table will be...
1
by: pStan | last post by:
Nubie Question...I'm sure this is simple, but here goes anyway. I have a small VB.Net application that uses a local Access Database. I want that same local data replicated to an Internet web site...
1
by: Me | last post by:
Currently I have an application that uses MS Access to store data. I have 150 users that connect to the network via VPN through out the world. We use Access data replication, which has has bugs and...
8
by: morleyc | last post by:
Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well....
2
by: m-flo | last post by:
Hi, I currently trying to develop a project that consists of 2 part: 1- central web application that is connected to MSSQL 2005 DB 2- an application that use a local MSSQL 2005 DB i want when...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.