473,405 Members | 2,167 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Backup sql file using vb6 code

1
The code below is my code to backup access file using vb6.0. How can i backup .sql file using vb6.0. Please easier code like this to understand clearly.


Expand|Select|Wrap|Line Numbers
  1. Dim Source, Destination As String
  2. Source = App.Path & "\db_registrar.mdb"
  3.     Destination = App.Path & "\Backup\" & Format(Date, "mmmm_dd_yyyy") & "" & Format(Time, "h_mm_ss") & ".mdb"
  4.     FileCopy Source, Destination
  5.  
  6.     MsgBox " Backup!", vbInformation, ""
Jun 13 '12 #1
1 3367
Rabbit
12,516 Expert Mod 8TB
Please use code tags when posting code.

Do the same thing... just change the path.
Jun 13 '12 #2

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

Similar topics

1
by: John S | last post by:
Hi All, I have several questions about checking backup file : a. When SQL Server receive a command : BACKUP DATABASE test to DISK = '\\pc1\netdb\BTEST', does it verify BTEST file before...
3
by: Jenny | last post by:
Hi, I want to use a button to display a pdf file. I have Windows 2000 server, IE 6 and Acrobat 7 with plug-in. I can use <a> link to display it. I search this group for js code but they...
3
by: David B | last post by:
I have this code to find a file, place it in C:\ temp, zip it up then send it to floppy in drive A:\. When I run it it comes up with error 53 - source file not found. However it gets as far as...
1
by: wolphie | last post by:
The IT shop I work in installed MS-SQL Server last week for the sole purpose of converting a large MS-SQL Server database to a format that Informix (our main database engine) can read. MSSQL...
3
by: Bernard Dhooghe | last post by:
Suppose a running database (DB2 UDB) with all containers being SMS based (file system as JFS or JFS2 on AIX). How to make a backup (online) by doing a file system backup and not a database...
5
by: Zenek | last post by:
Hello, I have: - server MS SQL MSDE (2000) - database 'COLLBASE' - table 'MAIN' - row: column 'NAME' value 'version' and column 'VALUE' value '003' I make backup files by SQL query.
5
by: mhifd009 | last post by:
I have just come back to coding after a break of 12 months, as you know remebering wat u knew can be hard, i created a macro or code that compressed another database (renamed to temp, then copied...
1
by: Bryan | last post by:
We have a SQL 2005 server running the following backup job: <font face="Courier New" size="2"><br><font color="blue">/* Created by <a...
2
by: Neil | last post by:
Is there a way to read a backup file to see if it contains a file without restoring the backup file? We are missing a record from a table, and I need to find out when it was deleted. We have...
4
ddtpmyra
by: ddtpmyra | last post by:
I have this a backup file from a disk and I have to copy it on my database. When I tried to restored it I got this below message. Originally I created a database called SnapShot using Server Mgmnt...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
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,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
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,...

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.