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

Did you use code to check the AllModules collection to see if it was in
there?  Access creates a busload of temporary objects with the ~ prefix
and they aren't intended to be seen, so they're well hidden.

Charlotte Foust


-----Original Message-----
From: Steve Erbach [mailto:erbachs at gmail.com] 
Sent: Friday, February 04, 2005 9:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2K: Oh, BROTHER! Have I screwed up or not?


Jim and Jeff,

Intersting code. I see that it relies on the table having been renamed
internally with a ~tmp prefix. I checked the MSysObjects table
immediately after my boo-boo (which still baffles me how I did it!) and
there was no object with my module name in it. I will give this a try,
though, for deleted tables if I ever need it. Thank you.

Steve Erbach


On Fri, 4 Feb 2005 11:13:17 -0600, jeffrey.demulling at usbank.com
<jeffrey.demulling at usbank.com> wrote:
> Just did a quick seach on google and found this.  Hopefully it might 
> help.
> 
> http://support.microsoft.com/?kbid=209874
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com