Wrox Home  
Search P2P Archive for: Go

  Return to Index  

interdev_programming thread: Working with database/master mode


Message #1 by "Peter Alldis" <alldis@z...> on Thu, 4 Apr 2002 17:22:04
I need direction here!

My ISP/Web server is remote to me. I use Interdev in Master mode to 
connect to it over the internet. I have set up a data connection to an 
Access .mdb file located on the web server. All seems well. I also have a 
local copy of the same database file which I can update using project 
explorer.

Am I right in assuming that if I open the tables (within the Interdev 
environment) and make changes to the data, upon closing the tables 
Interdev automatically overwrites the master (web site) .mdb file located 
on the web server? If this is the case and a visitor to the web site was 
to update the database (perhaps to register themselves with the site), 
whilst I was changing table data, would I then be overwiting the new data 
they had just entered when I close/save the table?

If the above is true, what is the best way to prevent overwriting of new 
data? Is it to use an ASP page to query the tables "live" using a 
recordset and then "update" etc etc or, perhaps preventing users accessing 
database, whilst I make changes, by redirecting to a default "Temporary 
page".

Hope this is clear. Thanks

  Return to Index