[AccessD] Weird Problem...for me anyhow

jwcolby jwcolby at colbyconsulting.com
Wed May 16 09:27:57 CDT 2007


>Do I get demoted to rookie for this?

OH YEA!  You lose one stripe for assuming that the user did anything.  You
lose another for not just doing a compact / repair before you try anything
else.  And you lose a third stripe for bothering so many people.

;-)

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Wednesday, May 16, 2007 10:18 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Weird Problem...for me anyhow

You know, I am feeling pretty damn silly right about now. This is the first
thing that I would normally try, but I guess I just sort of assumed (yeah, I
know, I know) that they would have done this before calling me, so I just
blew past this option.

As you probably guessed by now, it worked. Do I get demoted to rookie for
this?! ;o)

John W. Clark

>>> "Bryan Carbonnell" <carbonnb at gmail.com> 5/16/2007 9:27 AM >>>
On 5/16/07, John Clark <John.Clark at niagaracounty.com> wrote:
> I have a user who has setup her own DB...good that she has an interest 
> in Access...bad that she THINKS she is capable of doing this. I have 
> had to bail her out before, and once again my help has been requested. 
> OK, so maybe I got a little chip on my shoulder w/this one ;o)

<snip>

> I am about to tell them, "Here is your recovered database. You will need
to re-enter the data you've lost. Sorry!" But I wanted to run it by this
list first.
>
> Any ideas?!

Couple of Shots in the dark.

How about a Compact & Repair?

Failing that, create a new table with the same layout as the first, then do
an append from the corrupted table to the new table.

--
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well preserved
body, but rather to skid in sideways, totally worn out, shouting "What a
great ride!"
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list