Previous Thread

8/12/2006 10:12:55 PM    Replication on Web Server
Lets say I set up a web form to submit data to an MS Access database. 
 
That information is set to populate a table in the database.  Is it 
 
possible for that table or database to automatically replicate itself 
 
on the web server. 
 
My goal would be for the original data that was submitted to stay 
 
intact somewhere while still being able to edit a version of the data. 
 
So....I guess it would be something like this. 
 
Data from form goes to lets say Table 1 or Database 1. 
 
Data is replicated instantly to Table 2 or Database 2. 
 
Table 1 or Database 1 is editable (through web interface) 
 
Table 2 or Database 2 keep growing with original data. 
 
Possible? Wondering if there is a way to do this within Access. Or do I 
 
need to look to VB scripting? 
 
Thanks.



8/13/2006 10:19:19 PM    Re: Replication on Web Server
"TRU" <truwebs@gmail.com> wrote in 
 
news:1155445975.080630.238910@h48g2000cwc.googlegroups.com: 
 
Your question seems to me to have nothing whatsoever to do with Jet 
 
replication. 
 
It could be done in code. Basically you'd need to log all operations 
 
in your application front end, much like a server database with 
 
transaction logging. 
 
If you did all your edits through SQL, you could log the SQL and 
 
then run it against the other back end. But that's probably going to 
 
be harder to do than it sounds. 
 
-- 
 
David W. Fenton                  http://www.dfenton.com/ 
 
usenet at dfenton dot com    http://www.dfenton.com/DFA/