[AccessD] Weird Problem...for me anyhow

John Clark John.Clark at niagaracounty.com
Wed May 16 11:58:23 CDT 2007


Now wait a minute...I've got to debate this 3-stripe penalty...

The first two stripesl...trusting a user and no doing it myself are pretty much the same thing. I'll accept a one stripe penalty for that.

Bother so many people? C'mon...you of all people John? You must love helping us poor unfortunates. This list pretty much trained me. 

Can't I get some credits on this anyhow? I haven't been much of a bother, for quite a while now. I went from posting 2-4 questions a week, to about this many in a month, to once in a while, to now I hardly ever ask things...AND even know the answers to the questions of others...never quite beat the buzzer on answering though ;o)

BTW, I forgot to voice my Thank You to everybody that responded. 

I was a little embarrassed to be honest...in my defense, I have had a very hectic few days...came in Monday morning to discover one of MY sites completely down...computer AND phones. I adimantly declared it a tel co. problem, only to discover it was our problem...rare and odd, but ours none the less. Fixed it, only to have the phones go down again last night for a totally different, but connected cause. So a weird little access problem, from someone that created a "novice" program w/out my help, probably got doled out to my lesser fit brain cells ;o)

So, one more time...Thank you! Thank you! Thank you!!!

John W. Clark

>>> "jwcolby" <jwcolby at colbyconsulting.com> 5/16/2007 10:27 AM >>>
>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 

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