If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
I tend to agree with Lynn again... why discard the information? Just so
someone has to dig into tons of paper (if it van be found!) next time a department or HR manager asks a question? Uncle Murphy says they might never ask if you keep the data there, while if you don't the question will definitely come, and chances are it will be right after the deletion! What the heck... the customer is always right, even though they may be clueless... the sad part is it's harder to convince them they're asking for the wrong thing, than just go away and do it :-( Nikos Dana R wrote: Lynn I agree, but I am just the web designer and the administrators want a clean slate after 30 days, as there is no need to keep the records in the db...as a physical form is required by regulators with the employees signature that they attended- Thank you "Lynn Trapp" wrote: Dana, It still shouldn't be necessary to delete the data, especially if you need to keep a record of past training classes. You just need to see if the website has a field available that can set a given record to inactive and use an update query to set that field. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "Dana R" wrote in message ... Thank you for the solution, Just FYI the reasoning in deleting content after 30 days is because this database is linked with at website for a company intranet that registers users for a company training and a new class is every month so the same database can be reused... "Lynn Trapp" wrote: While there is nothing within an Access database to automagically delete records, the simple answer to your question is "Yes." You can create a delete query or queries to remove data and run those on some kind of a schedule. However, I would start by asking you WHY? What is the business reason for needing to delete data from your tables after 30 days? Databases are designed to store data. So, let Access do what it does best. The typical approach would be to simply inactivate records that are not currently needed. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "Dana R" wrote in message ... I need to have the contents of certain tables within my database auto-delete after a certain period (i.e. contents in table one delete after 30 days)of time. Is that possible? |
#12
|
|||
|
|||
I agree with both Nikos and Lynn present potential issues. Another solution
that may solve the issues with just deleting the data is to archive the data. Copy the data from the current database to a linked database and delete from the current “Live” database. This allows you remove the data from the database referenced by the website but still store it for reporting later. HTH Andrew "Nikos Yannacopoulos" wrote: I tend to agree with Lynn again... why discard the information? Just so someone has to dig into tons of paper (if it van be found!) next time a department or HR manager asks a question? Uncle Murphy says they might never ask if you keep the data there, while if you don't the question will definitely come, and chances are it will be right after the deletion! What the heck... the customer is always right, even though they may be clueless... the sad part is it's harder to convince them they're asking for the wrong thing, than just go away and do it :-( Nikos Dana R wrote: Lynn I agree, but I am just the web designer and the administrators want a clean slate after 30 days, as there is no need to keep the records in the db...as a physical form is required by regulators with the employees signature that they attended- Thank you "Lynn Trapp" wrote: Dana, It still shouldn't be necessary to delete the data, especially if you need to keep a record of past training classes. You just need to see if the website has a field available that can set a given record to inactive and use an update query to set that field. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "Dana R" wrote in message ... Thank you for the solution, Just FYI the reasoning in deleting content after 30 days is because this database is linked with at website for a company intranet that registers users for a company training and a new class is every month so the same database can be reused... "Lynn Trapp" wrote: While there is nothing within an Access database to automagically delete records, the simple answer to your question is "Yes." You can create a delete query or queries to remove data and run those on some kind of a schedule. However, I would start by asking you WHY? What is the business reason for needing to delete data from your tables after 30 days? Databases are designed to store data. So, let Access do what it does best. The typical approach would be to simply inactivate records that are not currently needed. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "Dana R" wrote in message ... I need to have the contents of certain tables within my database auto-delete after a certain period (i.e. contents in table one delete after 30 days)of time. Is that possible? |
#13
|
|||
|
|||
Yeah, I guess this makes sense.
Nikos ahuntertate wrote: I agree with both Nikos and Lynn present potential issues. Another solution that may solve the issues with just deleting the data is to archive the data. Copy the data from the current database to a linked database and delete from the current “Live” database. This allows you remove the data from the database referenced by the website but still store it for reporting later. HTH Andrew |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Compare fields and delete ONLY duplicate data, not entire record | Artmajor | General Discussion | 1 | September 8th, 2004 05:59 AM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
How do I delete multiple BLANK rows within data? | The Old Bailey | General Discussion | 2 | September 6th, 2004 12:08 PM |
auto new record on enter or data entry | Laura Q | Using Forms | 0 | July 27th, 2004 05:53 PM |