ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to make a mirror database ? (https://www.excelbanter.com/excel-programming/369892-how-make-mirror-database.html)

vumian[_59_]

how to make a mirror database ?
 

hi everyone,

i wanna create a mirror database as following:

i have 2 file :
1 - contain the main database
2 - contain the mirror. it mean, if the main database is changed, the
mirror change parallelly

how to do it, pls

thanks in advance.


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=570037


Jake Marx[_3_]

how to make a mirror database ?
 
Hi vumian,

vumian wrote:
i wanna create a mirror database as following:

i have 2 file :
1 - contain the main database
2 - contain the mirror. it mean, if the main database is changed, the
mirror change parallelly

how to do it, pls


Are you talking about Excel?

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]



zerosleep[_5_]

how to make a mirror database ?
 

make an excel file somewhere else that is exactly the same as the one
have, but read only for everyone else. anyway to do this at th
workbook level? I know how to do it at the cell level.

once again, many thanks for all the help

--
zeroslee
-----------------------------------------------------------------------
zerosleep's Profile: http://www.excelforum.com/member.php...fo&userid=1784
View this thread: http://www.excelforum.com/showthread.php?threadid=57003


NickHK

how to make a mirror database ?
 
Call WB.SaveCopyAs every so often, overwriting the previous file and marking
it Read-Only.
If you are looking for something more like database Replication, use a DB
product instead.

NickHK

"zerosleep" wrote in
message ...

make an excel file somewhere else that is exactly the same as the one I
have, but read only for everyone else. anyway to do this at the
workbook level? I know how to do it at the cell level.

once again, many thanks for all the help.


--
zerosleep
------------------------------------------------------------------------
zerosleep's Profile:

http://www.excelforum.com/member.php...o&userid=17846
View this thread: http://www.excelforum.com/showthread...hreadid=570037





All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com