Form in Access 2003

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

HI

I'm doing a application with access 2003, and I want to
implement it on my client Pc but he has Access 2002, is
that affect my forms style especillay if I use ".mde" file

Thanks
 
Chris said:
HI

I'm doing a application with access 2003, and I want to
implement it on my client Pc but he has Access 2002, is
that affect my forms style especillay if I use ".mde" file
Click to expand...

The default file format for 2003 (so I have heard) is still the Access 2000
format. This is also true of Access 2002. So unless you have changed that
your file should work on PCs with Access 2000 or 2002.
 
Hi Chris & Rick,

Compiled databases (.mde files) are only forward compatible, so they can
only be used in the version of Access in which they were compiled and later.
Further more, if you are working with the 2000 file format, you have to
compile that in Access 2000. Access 2003 has two natively used file formats,
the 2000 file format, which, as Rick mentioned, is the default format for
new database, and the 2002 - 2003 file format. Here is a break down of how
..mde databases will work based on the file version and product version that
compiled it.

2000 file format compiled in Access 2000 - works in Access 2000, 2002 and
2003
2002 - 2003 file format compiled in Access 2002 - works in Access 2002 and
2003
2002 - 2003 file format compiled in Access 2003 - works in Access 2003

In the specific case that Chris describes, you have two options: You could
use the 2000 file format and then compile the database using Access 2000 and
it will work for your client running Access 2002 as well as for those using
Access 2000. You could also use the 2002 - 2003 file format but be sure to
compile the database using Access 2002 so that your client can still run it.

In either case, you can still do you development in Access 2003. As long as
you don't use Access 2003 specific functionality, the concern is how you
create the .mde, not where you develop the .mdb.

Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top