[AccessD] A2K: Oh, BROTHER! Have I screwed up or not?

..nice find ...I can use that myself :)

William Hindman


----- Original Message ----- 
From: <jeffrey.demulling at usbank.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Cc: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>; <accessd-bounces at databaseadvisors.com>
Sent: Friday, February 04, 2005 12:13 PM
Subject: RE: [AccessD] A2K: Oh, BROTHER! Have I screwed up or not?


> Just did a quick seach on google and found this.  Hopefully it might help.
>
> http://support.microsoft.com/?kbid=209874
>
>
>
>
>
>             "Jim DeMarco"
>             <Jdemarco at hudsonh
>             ealthplan.org>                                             To
>             Sent by:                  "Access Developers discussion and
>             accessd-bounces at d         problem solving"
>             atabaseadvisors.c         <accessd at databaseadvisors.com>
>             om                                                         cc
>
>                                                                   Subject
>             02/04/2005 11:01          RE: [AccessD] A2K: Oh, BROTHER!
>             AM                        Have I screwed up or not?
>
>
>             Please respond to
>                  "Access
>                Developers
>              discussion and
>             problem solving"
>             <accessd at database
>               advisors.com>
>
>
>
>
>
>
> IIRC there is code out there (somewhere) to undelete an Access object. The
> only caveat is you can only retrieve the last object deleted.  Maybe
> someone on the list knows what I'm referring to??
>
> Jim DeMarco
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve Erbach
> Sent: Friday, February 04, 2005 11:55 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2K: Oh, BROTHER! Have I screwed up or not?
>
>
> John,
>
> Thanks for the thinking-while-typing. I went through the MSysObjects
> table and there aren't any objects that look like the deleted module
> with a tilde in front of its name. Nice try, though. Thanks.
>
> Steve Erbach
>
>
> On Fri, 4 Feb 2005 10:31:59 -0600, John Bartow <john at winhaven.net> wrote:
>> Hi Steve,
>> Since this is urgent I'm typing while thinking (which is dangerous)
>>
>> IIRC when deleting an object it is marked for deletion but not deleted. I
>> forget the way it is done exactly but I think it is by putting a "~"
>> character in front of the name. Once compacted the object go away.
>>
>> John B.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>
> ***********************************************************************************
>
> "This electronic message is intended to be for the use only of the named
> recipient, and may contain information from Hudson Health Plan (HHP) that
> is confidential or privileged.  If you are not the intended recipient, you
> are hereby notified that any disclosure, copying, distribution or use of
> the contents of this message is strictly prohibited.  If you have received
> this message in error or are not the named recipient, please notify us
> immediately, either by contacting the sender at the electronic mail 
> address
> noted above or calling HHP at (914) 631-1611. If you are not the intended
> recipient, please do not forward this email to anyone, and delete and
> destroy all copies of this message.  Thank You".
> ***********************************************************************************
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
> ------------------------------------------------------------------------------
> Electronic Privacy Notice. This e-mail, and any attachments, contains 
> information that is, or may be, covered by electronic communications 
> privacy laws, and is also confidential and proprietary in nature. If you 
> are not the intended recipient, please be advised that you are legally 
> prohibited from retaining, using, copying, distributing, or otherwise 
> disclosing this information in any manner. Instead, please reply to the 
> sender that you have received this communication in error, and then 
> immediately delete it. Thank you in advance for your cooperation.
> ==============================================================================
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>