RE: [MS_AccessPros] Backup both local and linked tables

 

One big drawback with Access is that you cannot write code to run in the very database you want to back up. So you cannot backup the FE from within it. You will have to either rely on a third-party software like Karenware Replicator (in our Files>0_Utilities_Addins>ptreplicator) or a custom script run via the task scheduler. I vote for Karen's software. It's free and very easy to set up.

 

Your BE should be backed up by your IT department's nightly backup. If you need more control, use the SSMA (SQL Server migration Assistant) for Access to convert the BE to a SQL Server database. That way you can set up a backup schedule. The most common is a weekly full, daily differential and hourly log backup.

 

Regards,

Bill

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 12, 2017 12:10 PM
To: crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Backup both local and linked tables

 

 

The local tables, capture login, connection, errorslogs for that client. We  have 12 clients that will be installed and each will have its own set of tables. We do have daily server backups and I suppose that will suffice.'

 

 

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

 

"Valar Dohaeris"

 

 

On ‎Thursday‎, ‎October‎ ‎12‎, ‎2017‎ ‎12‎:‎39‎:‎02‎ ‎PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

 

hi Art,

If this is a front-end/back-end, then what local tables would need to be backed up? What kind of local data would there be?

"access database on the server "

does the company not backup what is on the servers already?

have an awesome day,
crystal

On 10/11/17 4:10 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:

Is there away that I backup both local table and linked tables at the same time? I have my main database that has it primary tables in a linked access database on the server and then I have local tables that track local data.

I am trying to set it up so I can back them all up at once probably through VBA,

Thank you ,
Art Lorenizini    
Sd

 

__._,_.___

---

Posted by: "Bill Mosca" <wrmosca@comcast.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___