 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / July 2005tidying up old database
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 Why do you believe the database is "getting too large"? Have you already made a backup, then used Compact & Repair? (where you find this depends on which version of Access, unmentioned in your post). "Remove any files" doesn't really make sense if you're describing an Access database, which is a single file. Are you saying you are trying to remove records from tables in an Access database? Disk storage is CHEAP! Even if a record was not updated, what will you do if you need to look up historical information the day after you delete records? If you want to make a "snapshot" copy of the current state of your database, make a backup copy using Windows Explorer. Regards Jeff Boyce <Access MVP> > I want to tidy up a database and save and remove any files that has not been > updated over the last 3 years [quoted text clipped - 4 lines] > P.s. > I only doing this to stop the database getting to large I have a database of my engineers there are 15 men each doing between 8 and 10 jobs a day about 50% of these jobs are new customers so the database is getting very large and I am afraid that I may hit a maximum limit I am using access xp and split the database customers(8800 files so far ), engineers(20), and jobs(12000) > Why do you believe the database is "getting too large"? > [quoted text clipped - 29 lines] >> P.s. >> I only doing this to stop the database getting to large I am not familiar with your use of the word "files". I do not know how much information you are recording per engineer, per customer, per job. I don't know how your data is structured. Have you checked Access HELP for "specifications" -- you will find info about max capacity. Regards Jeff Boyce <Access MVP> > I have a database of my engineers there are 15 men each doing between 8 and > 10 jobs a day about 50% of these jobs are new customers so the database is [quoted text clipped - 35 lines] > >> P.s. > >> I only doing this to stop the database getting to large Is your system clock counting backwards? This post shows 3:10 on the 24th, but your previous one shows 4:00 on the 25th.  SignatureRick B > I have a database of my engineers there are 15 men each doing between 8 and > 10 jobs a day about 50% of these jobs are new customers so the database is [quoted text clipped - 35 lines] > >> P.s. > >> I only doing this to stop the database getting to large 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. SignatureRick B > I want to tidy up a database and save and remove any files that has not been > updated over the last 3 years [quoted text clipped - 4 lines] > P.s. > I only doing this to stop the database getting to large |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.