Redundancy

D

DS

I need to create a duplicate record into another database when I create
a record in the current one. I'm using the SQL INSERT Command. How
would I send a copy to another database with SQL? Also is this safe?
Thanks
DS
 
J

Jeff Boyce

Could you describe why you are creating duplicate copies of the same data
(i.e., what business need you are satisfying by doing this)? There may be
other options open to you...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

DS

Jeff said:
Could you describe why you are creating duplicate copies of the same data
(i.e., what business need you are satisfying by doing this)? There may be
other options open to you...

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
This is for a restaurant, so I need up to date backups.
Thanks
DS
 
J

Jeff Boyce

Backups of your database can be accomplished by simply copying the entire
database, rather than writing the same record twice every time you write a
record.

That said, you could use split front-end/back-end construction and link to
your "backup" database tables. Then, in each of your forms, you could add
code that would write (INSERT INTO) a copy of the record to the linked
table, perhaps in response to the AfterUpdate event.

Be aware, however, that you could have network/other issues that would allow
one database to be updated and the other not. If you are not ready to
undertake embedding each/every update in a transaction that ensures that
BOTH updates are completed, then reconsider simply making a backup copy of
the .mdb file as frequently as needed.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

DS

Jeff said:
Backups of your database can be accomplished by simply copying the entire
database, rather than writing the same record twice every time you write a
record.

That said, you could use split front-end/back-end construction and link to
your "backup" database tables. Then, in each of your forms, you could add
code that would write (INSERT INTO) a copy of the record to the linked
table, perhaps in response to the AfterUpdate event.

Be aware, however, that you could have network/other issues that would allow
one database to be updated and the other not. If you are not ready to
undertake embedding each/every update in a transaction that ensures that
BOTH updates are completed, then reconsider simply making a backup copy of
the .mdb file as frequently as needed.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
I considered copying the entire database, but this would have to be done
every 15 minutes and during that time I have no guarantee that someone
somewhere will be entering information. So back to the idea of every
transaction being written to two places. I would be doing it with an SQL
INSERT Statement, but...how would I do an INSERT to another Database. I
know how to do it to the current database, any help appreciated.
Thanks
DS
 
J

Jeff Boyce

Please re-read my previous response. Even though you have another database,
you can still link to tables in it, making them appear to be in your first
db.

Check out File | Get External Data | Link...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

DS

Jeff said:
Please re-read my previous response. Even though you have another database,
you can still link to tables in it, making them appear to be in your first
db.

Check out File | Get External Data | Link...

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
OK that makes sense now! Thanks
DS
 
Top