Re: MS Access Question

[Geoff Lane <geoff -at- gjctech -dot- co -dot- uk>]

On Monday, February 27, 2006, W. Kelly Oja wrote;

> Anyway, any ideas on some command that I can use to get the timestamps back?
> I do have one option and that is to go to IT and get an archived copy from
> two weeks ago, but I made major alterations early last week and getting the
> archived copy would require redoing everything I did early last week. Other
> than that ... well that's all I got.
---

You need to find out what the techy did. If he issued a global "UPDATE
<table> SET <timestamp column>" query, you'll need to get a copy of
the latest good backup. Rename the table in the backup and then
temporarily attach it to the live version. With that done, you just
update the live table with the timestamps from the old, leaving only
the interval since the backup was taken to do by hand.

If you don't completely understand SQL, perhaps you can insist that
the techies put it right for you, rather than have you struggle and
possibly make things worse?

HTH,

-- 
Geoff

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

WebWorks ePublisher Pro for Word features support for every major Help
format plus PDF, HTML and more. Flexible, precise, and efficient content 
delivery. Try it today!. http://www.webworks.com/techwr-l 

Doc-To-Help includes a one-click RoboHelp project converter. It's that easy.  Watch the demo at http://www.componentone.com/TECHWRL/DocToHelp2005

---
You are currently subscribed to TECHWR-L as archive -at- infoinfocus -dot- com -dot- 

To unsubscribe send a blank email to 
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40infoinfocus.com

To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to lisa -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/techwhirl/ for more resources and info.