[AccessD] MDE question

The real difference is the VBA version behind Access.  Access 97 was
VBA5, which used a different IDE and was non-standard to the rest of
Office 97/VB5.  Access 2000 - 2003 is built on VBA6 and shares the
standard VBA6 IDE.  Even in 2003, the 2000 file format is the default.
There is a difference in the structures (i.e., 2002 and 2003 have an
additional system table that doesn't exist in 2000) but each version
includes backward (not forward) compatibility.

Charlotte Foust


-----Original Message-----
From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] 
Sent: Thursday, August 18, 2005 8:11 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] MDE question


I was going to post about that.  From what I understand, the big change
was 97 to 2000.  2000 and up has the ability of using the '2000' format,
so you should be able to make a 2000 format mde that could be used in
2000, XP and 2003.  But I don't have the later versions to try that on.

Drew

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
Sent: Thursday, August 18, 2005 8:27 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MDE question


On 18 Aug 2005 at 9:16, John W. Colby wrote:

> Ahh.. OK, I did not know that.  That is not true for later versions
correct?
> I.e. AXP does not even attempt to "convert" an A2K app to AXP so this
isn't
> an issue, correct?
> 

Correct.  AXP has no dificulty opening an A2K MDE.

> As for "having to start from scratch" on those amateur apps, believe 
> me
that
> is a blessing!
> 

Don't I know it.  I' was just handed a new one yesterday to do some work

on:
Natural Keys, Fieldnames "Date" and 'Name" as well as included spaces, 
tables not normalised, macros galore etc, etc. And this one was
apparently 
built for a government entity by an AusAID consultant!


 -- 
Stuart


-- 
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