Re: tidying up old database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Please fix your system time. It looks as though you are trying to make your
post appear above everyone elsee's.

"remove any files that..." What do you mean "files"?

To remove old records, you'd need to look at a date field in the record. If
you don't have one, then yo ucan't do it.



--
Rick B



"Mr K Morris" <iuglhgvbhjgf@xxxxxxxxxxxxx> wrote in message
news:IK2dnY5_sO3r3X7fRVn-iQ@xxxxxxxxxxxxxxxxx
> I want to tidy up a database and save and remove any files that has not
been
> updated over the last 3 years
>
> how do I save files automatically to a old data file
> how do I delete data from a database automatically
> any help welcome
> P.s.
> I only doing this to stop the database getting to large
>
>


.

Relevant Pages

  • Re: Issues with CHANGE_TRACKING AUTO after initial index population
    ... There's a problem with 64 bit SQL 2005 server. ... Director of Text Mining and Database Strategy ... started the FT initial index population when our site activity is low. ... High activity on the data file. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Renaming control breaks module ?
    ... This seems like the kind of problem that a decompile might fix. ... Office Button | Access Options | Current Database | Name AutoCorrect ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ...
    (microsoft.public.access.formscoding)
  • Re: Access database stability problems
    ... The backend data files are even located on the same network drive on the server. ... I found out today that people running that database are NOT having crashes like we are. ... What I wanted to strongly recommend is moving your database to an SQL server of some kind, SQL Server 2005 Express if nothing else. ... You haven't said whether 'crashing the database' is just a matter of Access losing its network connection and screaming blue murder, or whether it's actually breaking the backend data file. ...
    (microsoft.public.windows.server.sbs)
  • Re: Third party tool required
    ... How does this fix data corruption? ... wrote our own table header repair utility because they would ... > What's so hard about writing your own database rebuild utility. ... > In our app we call this utilty installDB. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Existing Database - Create new or Fix existing?
    ... If you have spent lots of time developing the app, ... fix the issues you can (such as ensuring all ... I downloaded the free 'database checker' utility from ... Do I trawl through the report page by page and try to fix the issues one ...
    (microsoft.public.access.queries)