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