jwcolby
jwcolby at colbyconsulting.com
Wed Feb 16 05:11:21 CST 2011
In a true MDE the code is there, it is just in a PCode state, i.e. the source has been removed. John W. Colby www.ColbyConsulting.com On 2/15/2011 11:32 PM, Carolyn Johnson wrote: > Thanks. I'll see if I can find out if that's what they did. The database would not function properly without the code, though. . . . > > And I still don't know what the issue is with it being blocked by Windows 7. > > None of this makes sense, although that may be asking for too much. > > > Carolyn > ----- Original Message ----- > From: Stuart McLachlan > To: Access Developers discussion and problem solving > Sent: Tuesday, February 15, 2011 9:55 PM > Subject: Re: [AccessD] compiled .mde file allowing design view > > > Re-reading that old thread, it looks as though they possibly just did a "SaveAsText" on all of > the forms and reports in the MDE. > > -- > Stuart > > On 16 Feb 2011 at 13:46, Stuart McLachlan wrote: > > > The only way that I can think of for that to happen is that someone > > has used a tool to recreate the forms and reports from the original > > MDE into another file which they have given the same name. That would > > explain the absence of any code modules. > > > > I seem to remember one of our list members creating such a thing a few > > years ago. Hang on a minute while I search my archives...... > > > > Yep, Shamil came up with concept back in 2002. Last reference on the > > list was: > > > > "Shamil Salakhetdinov"<shamil at smsconsulting.spb.ru> > > Re: [AccessD] DBRepair (EatBloat+) Was: Re: AccessD Digest, Vol 84, > > Issue 23 Tue,16 Feb 2010 23:12:03 +0300 > > > > > > -- > > Stuart > > > > > > On 15 Feb 2011 at 21:20, Carolyn Johnson wrote: > > > > > I sent someone a database with a compiled front end / back end last > > > June. Now he has emailed me because the the forms and reports can > > > be viewed in Design view. > > > > > > The file he sent back (with .mde extension) does not run the startup > > > form, and it does allow me to open forms and reports in Design view. > > > The modules are all gone however. > > > > > > > > > This was an Access2000 database. I don't know what version of > > > Access his co-workers were using (he's just the messenger), but I do > > > know that the OS is Windows7. I had also heard from them last June > > > that they were having trouble opening the file -- getting a message > > > that Windows was blocking it. > > > > > > > > > It sounds like they found something to handle the problem of the > > > database being blocked by Windows 7 that ended up allowing design > > > view? Does anyone know what they might have done? The person I'm > > > dealing with doesn't seem to know. > > > > > > > > > > > > Thanks > > > Carolyn Johnson > > > St Louis, MO > > > -- > > > 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