Save Data

[dogbite via AccessMonster.com]

I need to save my data to a disk
I am using Access 2000
What is the best way to do it
I also need to save it 3 or 4 times a day
Thanks

 

[Duane Hookom]

Isn't this what normally occurs when you have tables bound to controls in
forms and users edit values?

 

[Smartin]

I need to save my data to a disk
I am using Access 2000
What is the best way to do it
I also need to save it 3 or 4 times a day
Thanks

Write a batch file to run on Windows scheduler. Note: it's not a good
idea to copy the MDB file when in use, so check for existence of LDB file.

HTH

 

[dogbite via AccessMonster.com]

Write a batch file to run on Windows scheduler. Note: it's not a good
idea to copy the MDB file when in use, so check for existence of LDB file.

HTH

I guess I might have put that the wrong way.
I need to save it to my Access DB and a data disk at the same time
Is there a way fo doing that?

 

[Duane Hookom]

"save my data to a disk" what format? CSV or what?

 

[John Vinson]

I guess I might have put that the wrong way.
I need to save it to my Access DB and a data disk at the same time
Is there a way fo doing that?

Your Access database - the .mdb file - IS on a data disk.

Could you explain what you mean by a "data disk"? a CD? a 3.5"
diskette? an external hard drive? or what?

John W. Vinson[MVP]

 

[dogbite via AccessMonster.com]

Your Access database - the .mdb file - IS on a data disk.

Could you explain what you mean by a "data disk"? a CD? a 3.5"
diskette? an external hard drive? or what?

John W. Vinson[MVP]

CD disk on a lop top

 

[John Vinson]

CD disk on a lop top

It's quite permissible to provide more information for the volunteers
here.

WHAT do you want to save to the disk? In what format? Do you want to
back up your Access .mdb file? or export the data in a table to a Text
file? or export the data in the table to an Excel spreadsheet? or
what? Do you want to replace the previous file, or create a new file
every time you update a table?


John W. Vinson[MVP]

 

[dogbite via AccessMonster.com]

[quoted text clipped - 8 lines]

CD disk on a lop top

It's quite permissible to provide more information for the volunteers
here.

WHAT do you want to save to the disk? In what format? Do you want to
back up your Access .mdb file? or export the data in a table to a Text
file? or export the data in the table to an Excel spreadsheet? or
what? Do you want to replace the previous file, or create a new file
every time you update a table?

John W. Vinson[MVP]

I would like to save just the data I enter on my data entery form

 

[dogbite via AccessMonster.com]

[quoted text clipped - 12 lines]

John W. Vinson[MVP]

I would like to save just the data I enter on my data entery form also any new data that is added to a record set

 

[John Vinson]

I would like to save just the data I enter on my data entery form

I understand that, dogbite.

What I don't understand - and what I asked, and you did not answer -
is: HOW do you want the data saved?

Do you want it as a Text file such as

31;"John";"W.";"Vinson";#5/16/1946#;

or do you want it as an Access database? Or do you want it as an Excel
spreadsheet?

Please explain WHAT you want, and WHY you want it. You have the data
stored in your database; why do you want each record saved, as you
type it, into your Access database? What benefit do you expect to get?

John W. Vinson[MVP]