Modules & VBA :: Create Backup For Table In Another Database?

Jan 7, 2014

How to create backup for my table in another DB with VBA ....

View Replies


Modules & VBA :: Create Backup Of Database On Exit In Different Directory

Dec 20, 2013

I am looking to create a backup of a database on exit in a different directory then where I am storing the database now.

View 3 Replies View Related

Modules & VBA :: Command That Will Create Backup Of Access Database Once Every Week

Feb 24, 2014

Im trying to create a command that will create a backup of my access database once every week. here is the code I've got so far. it works, but not once a week but every time I start the access:

MsgBox ("Hello! Starting Backup procedure")

Dim DateOfBackup As Date
Dim strSourcePath As String
Dim strSourceFile As String
Dim strBackupFile As String
Dim SQL As String


View 2 Replies View Related

Modules & VBA :: Backup / Zip And Email Copy Of Database Programmatically

Sep 11, 2013

I need a way that I can simply have a User click a button on a form of the database and it will do automatically create a zip file of the entire database and start Outlook and attach the zip file and send it to me.....

View 4 Replies View Related

Modules & VBA :: Backup Records Programmatically Daily To Another Table

Jan 8, 2014

i have 2tables,table1=productid,ProductName,Qty table2=Productid,productName,Qty,date(). I want to be able to backup Records programatically daily from table1 into table2 OnClose.But i do not want duplication of record in the same day. If changes occurs in table1 after backup,table2 should be updated Programatically.

View 1 Replies View Related

How To Create Backup Of Tables

Aug 14, 2011

Not sure where this question must be posted! I would like to create code in VBA to backup tables in access. I am not sure where to begin, but what I would like to do is the following:

When the user signs in I want to backup the database/tables
When the user sign off I want to back up the database/tables.

View 2 Replies View Related

Backup BE Database

Jul 6, 2005

I recently created a database with an FE and BE, and I want to be able to back up the BE from the FE. In the FE, I added a menu item "Back up database...", and it works good for the FE, but I want it to back up the BE, where the data is located. The reason that I like the menu item is that it opens a "Save Backup As" dialog box, and it also adds the date to the name of the database. Also it will be easier for the people that are using the db.

View 1 Replies View Related

Backup Database As

Jul 10, 2006

what would possibly cause a "Backup Database As" dialogue box to appear? it's the same as the "save as" box and allows you to save a copy of the access file you're working on but it says "Backup Database As" at the top.

it seems to come up periodically and im not sure what might be causing it.


View 2 Replies View Related

Backup Database Is 'read Only'

Feb 13, 2006

Hi All,

I created a database in Access and of course password protected the backend version. As a matter of course I backed up the mdb to cd in case of emergency.

Our network has been taken down due to some virus being bought in by a laptop user so I wanted to reinstall the mdb from the cd to my c: drive.

The problem is that the file is saying that it is 'Read Only' which I think is down to the password protection i put on there.

Is there a way I can get round the security?

I promise I am not a hacker!



View 2 Replies View Related

Backup Database Online ?

Jun 12, 2006

I read a lot of threads and some KB articles before this, but am still confused.

Can a copy of the BE database be made on the Server while users are logged on ? Max No. of users is 7.

Does copying a BE while work is going on lead to corruption in the database.
Right now i make a copy of the database thru code and then compress the copy for a backup.

View 2 Replies View Related

Autiomated BackUp Of Back End Database

Aug 17, 2005

We are currently running a FE / BE splitted database abd would like to back the back end up (to a sepearate location) every 15 minuutes by using the On Timer event.

Troiuble is, I believe I cant use the CopyDataBaseFile method whilst other users are in it and it would be too much hassle kicking everyone off!

Manually copying and pasting is good, but would really like to crack this one

Any suggestions please?



View 3 Replies View Related

Search Employees Backup Database?

Dec 16, 2011

Attached i have a Database with 3 Tables.

-Table MA's. is the just a table were you can select if an Analyst is at the office or not. so if the check box is selected the analyst is available.

-Table Backups. We have Alias which is a reference code to a supplier the 1 Analyst and then Backup 1 and backup 2

-Table suppliers are just de supplier details.

what i whould need is when in the MA's table an Analyst is not selected a macro or query should search for backup 1 and replace it. when the backup 1 is not available as wel than backup 2 should be put in place.

When no backups are availeble then a message can put in the cell like"No Backup Available'.

This result can be put in a new table named. Decksplit with then the Supplier Alias, Supplier Name, Analyst

View 4 Replies View Related

Making Daily Backup Of Database?

Oct 29, 2013

As my database is growing and hold more and more data i want to make a daily backup to the local hard disk (it works on a network now) automatically.The way i want it to work is as follows :

When a user quits the application i want to check if there is a copy already existing with the date of today.

If it does it skips the copy process and just quits.

If it doesn't, i want it to make a backup in a directory. if the directory doesn't exist it must be made.

The backup file name must hold the date of today off course.

I realize that i have to have a procedure to delete obsolete (outdated) backups as well, but ill worry about that later.

Off course Ive tried this a few times, otherwise i wouldnt ask it here. But i seem to fail every time..

View 5 Replies View Related

Backup Database By Use Of Command Button On Switchboard

Sep 3, 2004

Is it possible to create a command button on an Access switchboard that will automatically backup a database? What code would I need? The command button wizard doesn't handle this task.

View 14 Replies View Related

General :: Backup Database At User Side

Oct 4, 2012

I have developed an access database, and prepared its run time exe file. My question is how to develop the database so that the user can regularly backup the database?

View 1 Replies View Related

General :: Backup Database Automatically Per Week

Jul 29, 2013

I want backup my database automatically per week,what should I do?

View 1 Replies View Related

General :: Backup BACK-END Of A Split Database

Jan 24, 2014

I am trying to use VBA to backup the BACK-END of a split database (so I can automatically archive selected data). If I use FileCopy I get a message that the BACK-END database has not been found.Obviously I could 'unlink' the BACK-END, copy it and 're-link' it..Is it possible to copy the BACK-END tables(not just the links) into the FRONT-END and get at them that way?

View 2 Replies View Related

General :: Saving Database As Backup With Different Date

Nov 7, 2012

I'd like to have a button on my dashboard that gives the user the ability to back up the database and save it with a different date. For example, existing database called "Fishing.accdb" and I'd like to have code behind a button that allows the database to be saved as "Fishing0711.accdb"

I'm trying to avoid the user having to go into the File Save as menu system....I've tried the docmd.copyObject method but can't get it to work

View 10 Replies View Related

Modules & VBA :: How To Create New Lock File Within Current Database

Apr 7, 2015

What I'd like to do is have an "export button", where the OnClick event, exports a single table into a new accde file. This would allow the end users to zip this file up and send it to me.

Because of all sorts of stupidity, I have no network capability and must send data back and forth via email.

I have digressed to a replication table that needs to be uploaded, once data is entered by the users...

Because the files can get relatively large (for emailing purposes), I am trying to figure out how I can get just one table from them vs. sending the whole application file back to me... It's pretty vital that they not be able to edit the table because that could really mess up the process.

So any way to create a new lock file from within the current Db?

View 1 Replies View Related

Access 2007 Backup Menu Won't Back Up My Database

Jan 23, 2008

I'm using Access 2007, with what I think is a normal database that I've built up over the past month (maybe 15 tables, <1000 records, 20 queries, 4 or 5 reports and macros). I'm not an experienced Access programmer, so I don't think I'm doing anything fancy with security settings or any other such stuff. (If I have, it's surely by accident, not by intent.)

When I try to back up the db using the simple office button -> manage -> backup method, access generates a date-stamped backup filename and opens a file save dialog for me, but it ALWAYS fails to backup the database. I always get the same error message when I click save, whether I save on my machine, or on a network drive.

"Could not use '<path to the current database dir><backname>.accdb; file already in use."

This same error occurs when I create a new blank database with a single Table1 in it, so I don't think it's my database.

Does anyone have any idea why this might be happening? I scoured the net for help, but nothing. I checked various Access forums, but nothing. So I arrive here after I've done my homework... thanks

View 11 Replies View Related

General :: Access (2010) - Database Creating Backup By Itself

Jun 13, 2013

Why Access (2010) database is creating backup copy by itself?

View 2 Replies View Related

Modules & VBA :: Error - Microsoft Access Was Unable To Create MDE Database

Sep 19, 2013

I have tried to create an MDE database and receive the message "Microsoft Access was unable to create an MDE database" I deleted all unnecessary tables, queries, forms and reports and still receive this message.

how to fix this problem in MsAccess 2003?

View 6 Replies View Related

General :: Difference In Size Between Actual Access Database And Its Backup

Aug 19, 2014

I am using Access 2007 database in work environment. When one of my colleagues tried to update some records in a table, it created a backup of the database.

The issue is that the size of the actual database is much smaller than the size of the backup. However all the data are present and I don't think any data has been deleted.

But I don't know why there is a difference in size?

Some of the tables in the database are linked from MS SQL Server.

View 4 Replies View Related

Auto Backup On Entire Database Close / Forms Included

May 10, 2014

I have a database with multiple forms and I would like to on close I would assume of the form, save a backup to a specific folder. This will all change once I move the database to the server but for now want a backup on my machine. Here is my code:

Private Sub Form_Close()
Call db_backup
End Sub
Below is in a module


The problem is when I run this the program will give me an error saying: runtime error 438 object does not support this property or method

View 8 Replies View Related

Cannot Create New Table Linked To ODBC Database

Mar 7, 2006

I can edit/open existing linked tables (to Sage Line 50, v12) but not create new ones.

Following the procedure:
- New
- Link Table
- File Type: ODBC databases ()
Nothing now happens!

I can open the Link Table Manager to update previously created links.

Any ideas?

I'm using MSAccess 2003 on a brand new machine.

View 1 Replies View Related

Modules & VBA :: Backup Backend Using Batch File?

Aug 14, 2014

I've created some code to make a backup of my database backend. I've tested it and it seems to work fine, I just have some questions about it's use. Here's the code:

Public Sub backupBackend()
Dim TestFile As String
Dim strReplFile As String
Dim copyFromLocation As String
Dim copyToLocation As String
copyFromLocation = "S:Trust 2 AnalysisData"


It will be triggered by a button push. It creates a batch file to do the copy operation and then delete itself.

In an ideal world I would schedule the backup at a safe time through the Windows scheduler, but our IT department won't allow me to do so.

The concern I have is that we could potentially press the backup button while a user is performing an action that writes/modifies data. If this were to happen would my backup potentially contain corrupted data?

If so, is the workaround to simply press the backup button when nobody is using the database?

View 3 Replies View Related

Copyrights 2005-15, All rights reserved