Archive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access 2000 how do I archive records? Is there a way to archive and keep
records searchable.
 
Anna said:
In Access 2000 how do I archive records? Is there a way to archive and keep
records searchable.
Click to expand...

Create a new yes/no column on the table and name it Inactive. If the
record's Inactive column is checked, it's archived. If it's not checked,
it's active. You can change existing queries to use the Inactive column to
display only active records.
 
Yes, add a Yes/No field named Archived.

In your queries use criteria of 0 ( zero ) to pull current records.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting corrupted zip archive 1
Outlook Deleting folders in Outlook and Outlook Archive 1
How can we convert OST to PDF file format? 1
PowerPoint Transition/animation to pass from paragraph to lines 0
I need a data base for recording archive or old records 1
Exporting and Zipping Files with Access VBA 4
To archive, or not? 4
How can I Manually Change Access Primary Key ID Fields ? 2

Back
Top