managing data

[Paul B.]

I have a number canceled accounts clogging up my
database. What's the best way to separate these from the
rest. Do I need a new database? Or is there some way to
hide the info? Any suggestions?

 

[John Vinson]

I have a number canceled accounts clogging up my
database. What's the best way to separate these from the
rest. Do I need a new database? Or is there some way to
hide the info? Any suggestions?

How can you identify an "account" (Access doesn't have "accounts", I
presume that's part of your data rather than part of the database
design) as being canceled? Is there anything in the table record
itself?

If so you can run a Delete query to permanently and irrevokably delete
the canceled records (before you do this, MAKE A BACKUP and decide
whether you might want end-of-year reports including the cancelled
reports!). Or, you can create a Query selecting only the active
accounts and base your forms and reports on this query.

It's *your* data - you need to decide how to handle it! Access gives
you a variety of tools to do so; if you need help with specifics,
please post back!