How to synchronize a Table?

  • Thread starter Thread starter Mota
  • Start date Start date
M

Mota

Hello;
My program has several tables,but one of them changes daily.For the
safety,we want ot keep a backup on a removable media rather than our Hard
Disk.For the program file is too big to be placed on a floppy,i decided to
make a blank DB on a floppy disc,and keep this table in it.Now the problem
is to synchronize this table with its pair in the main program that is a
Design Master,programmatically.Is there a trick to synchronize or update
just one table of a DataBase,with a copy of it in another DataBase (a one
table DB) thru code?
Thank you in advance.
 
Mota,
1. Make an empty database named 'Backup' and save to your floppy disk.
2. Use the Query wizard to make a new Select query, selecting the table you
want to backup with all fields you need.
3. After finishing the query wizard, switch to design mode (if not there
already), change the query type from Select query to 'Make Table' query.
From the dialog that pops up, browse to the Backup database you saved on
your floppy disk and choose what you want to name the back up table
(probably the same name as your original table).

You could create a button on a form (or the Switchboard) to run your backup
query each time you need a new backup.

Hope this helps,
Kjartan
 
Mota,
1. Make an empty database named 'Backup' and save to your floppy disk.
2. Use the Query wizard to make a new Select query, selecting the table
you want to backup with all fields you need.
3. After finishing the query wizard, switch to design mode (if not there
already), change the query type from Select query to 'Make Table' query.
From the dialog that pops up, browse to the Backup database you saved on
your floppy disk and choose what you want to name the back up table
(probably the same name as your original table).

You could create a button on a form (or the Switchboard) to run your
backup query each time you need a new backup.
Click to expand...

that all sounds good, but if this is really a critical table i would not
rely on a floppy disk or drive.
copy to network or, zip, or cdrw.
 
mcnewsxp said:
that all sounds good, but if this is really a critical table i would not
rely on a floppy disk or drive.
copy to network or, zip, or cdrw.
Click to expand...

True!... a floppy is not a reliable media and his table better be small not
to exceed the small floppy size...
 
CDRW is the best option,but can it be done by all users fully thru a button
and without a third party burning CD?What is important for me is that all
process be done in one step and through a code snippet.What u did if you had
such a problem?
Thank you for your help.
 
In addition,whenever i run that query,new made table will get a new name
(original name plus a 1 and so on),so in the function i must write to import
its data to the main DB in critical times,i cant count on the backup table
name.Is there any other way to keep my backup table synchronized,rather than
recreating it every day?
Thank you again.
 
Sorry, I have never coded to write directly to a CD and don't know how to.
But search the visual basic help for 'NewCurrentDatabase' and you will find
information on how to create new databases and tables by code. You could
select a network or hard drive path, name the tables differently each time
and copy your table to that new table.
 
KHV said:
Sorry, I have never coded to write directly to a CD and don't know how to.
But search the visual basic help for 'NewCurrentDatabase' and you will find
information on how to create new databases and tables by code. You could
select a network or hard drive path, name the tables differently each time
and copy your table to that new table.
Click to expand...

you could share the writable cd drive, but propably would run in to
buffer under run errors.
network drive would be best.
 
Back
Top