A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

auto delete data



 
 
Thread Tools Display Modes
  #11  
Old May 4th, 2005, 12:48 PM
Nikos Yannacopoulos
external usenet poster
 
Posts: n/a
Default

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  
Old May 4th, 2005, 07:45 PM
ahuntertate
external usenet poster
 
Posts: n/a
Default

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  
Old May 5th, 2005, 10:41 AM
Nikos Yannacopoulos
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.