Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
website hosted by other company
- Thread starter rry2k
- Start date
Well, if you are using SQL Server, then you can set up a trigger that can do that... I have heard that Access has a "pseudo-trigger" that you could probably set up to do such a thing --
The "best" way that I have found to do this is to set up intranet interfaces to UPDATE, DELETE, INSERT, etc... new data to the database, and then, simulateously, do the same UPDATE, DELETE, INSERT on the web version of the database -- running the exact same procedures on both databases at the same time -- it will ensure that the databases stay in sync.
Paul Prewett
The "best" way that I have found to do this is to set up intranet interfaces to UPDATE, DELETE, INSERT, etc... new data to the database, and then, simulateously, do the same UPDATE, DELETE, INSERT on the web version of the database -- running the exact same procedures on both databases at the same time -- it will ensure that the databases stay in sync.
Paul Prewett
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question