jwcolby
jwcolby at colbyconsulting.com
Wed May 16 12:10:05 CDT 2007
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