We help IT Professionals succeed at work.

Access 2013 - copying the original file

My OS is win 7 Prof 64 bit and I use Office 365, and I have a small Access 2013 file which i want to secure it, but before doing that I want to make a copy of it, preferably what I make changes on the original will also be reflected on the copyied version, and vice versa.  
In earlier versions of Access there was this replication method, but I do not know what is a safe method in Access 2013.  Hope the experts can please guide me the steps. thank u.
Comment
Watch Question

Distinguished Expert 2017
Commented:
Replication is no longer supported in Access 2013.  Every time you change the master copy, you will need to distribute it to the other users.  A very simple way of doing that is to place a copy of the FE in a shared network folder.  Also add a .bat file to copy the FE from the network drive to the user's local drive and open it.  Then give each user a shortcut to the .bat file.  The distribution will be come automatic.  Every time they click on the shortcut, it opens the .bat file and that copies the FE and opens it.  Here's mine:

md c:\ClientMgt
del c:\ClientMgt\AOAClientManagement.accdr
copy \\newfiscal\Afox\AFox\AccessApplications\ClientMgt\AOAClientManagement.accdr c:\ClientMgt
c:\ClientMgt\AOAClientManagement.accdr

There are other more sophisticated distribution tools out there.  Even some that are free.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
i want to secure it
...Secure it how?

Also can you explain the need for this "Copy"?
My guess is that what Pat posted should be what you are after...
But Replication was a way to update "Off network" databases.

For example, you had a corporate Inventory (or Sales) database.
...and you also had salespeople who traveled and also had the need to "update" this database remotely (via their laptops) that were not connected to your network.)
Replication allowed these users to return to your headquarters and "sync" (for lack of a better word) there remote databases to the corporate network.
This system was not without issues (for example: a salesperson selling items that they did not know just went out of stock)
So there was a series of "Accept this change?" questions you were forced to answer for each transaction discrepancy.

This was before VPN's and the like...

JeffCoachman
in response to jeffrey, The reason for my copying is that I am trying to secure the original file on a thumb drive, and just to be on the safe side thought i would have a good copy elsewhere in case the security feature does not work and does more harm where the file is not accessible etc.  
I think Pat's strategy seems to be a workable one, which I would have to research further.  
Thank u both for your inputs.

Author

Commented:
in response to Pat, thank u for your response.  I am interested to know the names of the distribution tools and also their links for me to take a look.  Thank u again.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
OK

I am sure Pat can help you with this.
Distinguished Expert 2017
Commented:
My strategy has nothing to do with what you are asking.  My suggestion applies to distributing updated copies of the FE to all the users.  making a copy for yourself simply requires copying the file.  I don't understand why replication is involved unless you are thinking that you want some method of updating your backup automatically whenever the FE changes.  If you want something that sits in the background and backs up changed files, look into Carbonite.

Author

Commented:
in response to Pat, do u think SyncToys might also work too.  i do back up using this, but i have not recovered any of the backed up dataset yet.  Thank u.
Distinguished Expert 2017

Commented:
I have no experience with SyncToys.  I've been using Carbonite for many years and I have had to recover files from it.  Single files are pretty easy to recover.  I even recovered a whole disk.  It was painful and slow but it worked.

Author

Commented:
thank u for your suggestions.