[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

i want to know the backup procedurs of database through vb

i am devoloping a Software like production managment. i want to Know how to make the weekly backup or monthly backup or the yearly backup procedures through vb? i want to know the algorythem as well as coding? i am using Ms Access as my backend.
0
ARUNKUMAR20
Asked:
ARUNKUMAR20
1 Solution
 
TigerZhaoCommented:
quickly, Copy mdb to other mdb. Don't forgot close connection first.
0
 
xchaixCommented:
dear arunkumar,

for me ..i just make a simple form just to handle it..

you can create a checkbox with caption weekly, monthly and yearly..

then press a command button.. it will copy the database to the new database.. *please don't use same name*
before that make sure you close all the connection to the database

and 1 more solution is.. you use a date comparison.. to get weekend try used format function.. eg.

format(date,vbFirstJan1)

and so on..

-chai-
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now