Re: MS Access Question

Subject: Re: MS Access Question
From: Geoff Lane <geoff -at- gjctech -dot- co -dot- uk>
To: TECHWR-L <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Mon, 27 Feb 2006 14:56:56 +0000

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?




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!.

Doc-To-Help includes a one-click RoboHelp project converter. It's that easy. Watch the demo at

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

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 for more resources and info.

MS Access Question: From: W. Kelly Oja

Previous by Author: Re: Tolerance in text
Next by Author: Re: Most annoying word
Previous by Thread: MS Access Question
Next by Thread: RE: MS Access Question

What this post helpful? Share it with friends and colleagues:

Sponsored Ads