[AccessD] Weird Problem...for me anyhow

Charlotte Foust cfoust at infostatsystems.com
Wed May 16 12:58:10 CDT 2007


 >>if they don't want to be bothered they are on the wrong list.

LOL Especially with *you* here, John!

Charlotte

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

Yea, that is what the list is for.  I can't count the times I have
pressed the send only to have the answer pop into my head.  

As for bothering others, if they don't want to be bothered they are on
the wrong list.  ;-) 


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 12:58 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Weird Problem...for me anyhow

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


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