473,569 Members | 2,772 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Vba code to back up access 2007 automatically

1 New Member
Hello,
I am relatively new to access 2007.I am developing a database at present and need help on how to include a back up button with vba code that will back up the database when a user presses it.
Oct 21 '12 #1
3 2683
zmbd
5,501 Recognized Expert Moderator Expert
Method depends on how your database is setup.
Do you have a front and back end (split) database or just a all-in-one arrangement?
Oct 21 '12 #2
twinnyfo
3,653 Recognized Expert Moderator Specialist
Yes, many ways to do this. You can even schedule regular backups without requiring the user to press any buttons.
Oct 22 '12 #3
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
The simplest approach is to simple do a filecopy of the database. This can be rather space consuming on a harddrive though.

If you are in a corporate environment, I would recommend you talk to the IT guys and find out how often network locations are backed up, and for how long data is stored.
Oct 22 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
3253
by: bobdydd | last post by:
Hi Everybody I am currently updating a 2000.mdb to a 2007.accdb and I am trying to use the 3.6 DAO Object Library in the tools>references in the vb editor. This produces an error "Name conflict with an Existing Library" and yet I need this to run the following code. I have a combo property set to "Limit to List" and on the "not in list...
17
7652
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running...
16
11050
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in...
0
1159
by: tingler0 | last post by:
Please excuse me i am new at doing code for access and i am trying to teach myself, i have a form of which is also linked to a query for company contacts. in the form when the shipper is being entered it will query from the query of company contacts when the correct company name is selected i would like to have the form populate the shipper...
4
2247
by: TheScullster | last post by:
Hi all This must have been covered already, but Google (or my use thereof) is failing me! We have a company database originally created in Access 2000. The backend is located on a Win2003 server. The front end is on clients running Office 2003. The obvious question is.... will this front end work on a client running
9
4483
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd like to know is the stability, speed & ease of use of both the products. I believe Access 2007 has a new file format too and that it may be...
1
1917
by: Raven7738 | last post by:
Hey, I have an autoexec macro in my program. When the frontend of the program opens up, I want the macro to run a module to check the local drive (C:) for the same program. If the program is in the C: drive, I want the open program to overwrite the original program. If not, I want it to save a new copy in the C: drive. I also would like...
3
3365
by: coalminer | last post by:
I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" and "Microsoft Office 12.0 Access database engine Object Library." The stuff...
0
1111
by: Sam Anderson | last post by:
How can I dynamically create ms flexgrid activex control through code in access 2007?
4
3172
by: mroberts50 | last post by:
On my form I have an option box for Band Option and a field box for Band Amount. When I click the Band Option box I want it to fill in the Band Amount field for 500. But it will not work and I cannot figure out why. Here is the code I am using, my option is True/False. Private Sub Band_Option_AfterUpdate() If (Me!Band_Option) = Then ...
0
7697
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
6283
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3640
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1212
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.