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