Live Updating and Changes to Access DB

  • Thread starter Thread starter Jay7
  • Start date Start date
J

Jay7

I am trying to find out if and how a database
administrator can make data or structural modifications
to a database that is live without affecting the normal
operation.

Example...Problem >

A database is active and records various user information
when users go on the website. I usually download the
database, add a new table or field to it, then upload it
again. The problem is that any user information that is
recorded while I was making changes is obviously lost
because the new database is uploaded and replaces the old
one.

Solution > Is there any way an active database can have
changes made to it (add new table or fields) without
interupting the normal operation of it. Can it only save
the changes instead of replacing the entire database???

Completely stuck!!!
Any suggestions would be greatlfully appreciated.
Thanks
..
 
For most, if not all, design changes, you need exclusive access to the
database.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
You can do it with replication. Do you changes in a replica and sync with
the master.
I usually just take the site offline, do the changes, then bring it back
up....

rh
 
Back
Top