Backup Data

[Guest]

I have a database with several fields in it.

I want teh database to automatically backup the fields each day into a new
table just for that specific field and categorize them by date.

Any suggestions?

 

[Lynn Trapp]

There is no need to do that. Just create a query that pulls the fields you
want and run it whenever needed.

 

[Arvin Meyer]

Use an Insert (Append) query:
Current database:
INSERT INTO tblBroker ( BrokerName, Address, Phone )
SELECT tblBroker.BrokerName, tblBroker.Address, tblBroker.Phone
FROM tblBroker;

Another database:
INSERT INTO tblBroker ( BrokerName, Address, Phone ) IN
'S:\Database\DataTables.mdb'
SELECT tblBroker.BrokerName, tblBroker.Address, tblBroker.Phone
FROM tblBroker;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Well it did transfer the data but I think I need to provide you with more
information.

I want to archive daily information on stocks. I have the source that
updates automatically, but I want to archive end of day information (and
possibly automate it so as long as the database is open it archives it at a
certain time each day). My most pressing issue is taking each piece of data
and pushing it into a table for just that data with a row heading for the
date and a column for the symbol of the company. If you need amplifying
information please ask and thank you for the help so far.

 

[hero]

74565756756

 

[Arvin Meyer]

I'm not sure what you're asking. If you want a timestamp on the destination
table, just add a date/time field and set its defaultvalue property to:

=Now()

There are no Triggers in JET (Access) but you can use the Timer event of a
form to append records at specific intervals.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access