Archive

[woody.quinn]

In Access 2000. Would like to create a Journal database,
such that I can "archive" (move) data older than 30 days,
either to an "archive" db or to CD. Table would include
auto date and time fields.

 

[Gina]

Maybe I'm missing something but what's the question?

 

[Allen Browne]

See:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

The article explains when to archive, and how to archive safely to a
separate archive mdb file.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
message
news:1b7cf01c420c8$3b5c4fb0$a301280a@phx.gbl...