Access 2002 deployment

[Scott]

Hi,

If we want to compile an Access 2002 database and distribute it to
others, will the compiled software run on any PC, like Windows 98,
Windows 2000, etc.

Also, you don't have to have Access 2002 in order to run it do you?

Thanks!

[Brendan Reynolds]

Access 2002 requires Windows 98 or later, it will not run on Windows 95.

The target PC will need Access 2000 or later installed, either the retail or
runtime version.

You can develop applications in Access 2002 that will run under Access 2000,
provided that you are careful to avoid any new features that were not
supported in the earlier version, that you do not use the new (optional)
Access 2002 file format, and that you deploy an MDB, not an MDE. You have to
convert to the new Access 2002 format if you want to create an MDE in Access
2002, and the resulting MDE, being in Access 2002 format, will not run under
Access 2000.

Alternatively, you can develop in Access 2002 or 2003, using the Access 2000
format, and then use Access 2000 to create an MDE for distribution to users
who have Access 2000.

--
Brendan Reynolds

"Scott" <sb*****@netins.net> wrote in message
news:be**************************@posting.google.c om...

Hi,

If we want to compile an Access 2002 database and distribute it to
others, will the compiled software run on any PC, like Windows 98,
Windows 2000, etc.

Also, you don't have to have Access 2002 in order to run it do you?

Thanks!

[Lyle Fairfield]

sb*****@netins.net (Scott) wrote in
news:be**************************@posting.google.c om:

Hi,

If we want to compile an Access 2002 database and distribute it to
others, will the compiled software run on any PC, like Windows 98,
Windows 2000, etc.
No.
Also, you don't have to have Access 2002 in order to run it do you?

Yes.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Larry Linson]

"Scott" wrote

If we want to compile an Access 2002
database and distribute it to others, will
the compiled software run on any PC,
like Windows 98, Windows 2000, etc.
Access does not provide the capability to "compile to an executable", but if
you get the Office XP Developer Edition, you can distribute your Access
database with runtime support for users who do not have Access installed.
What is called "compile to MDE" in Access simply produces tokenized output
for the code, so that the code cannot be modified by the user, but does not
produce an executable.
Also, you don't have to have Access 2002
in order to run it do you?

As Brendan has said, if you do not distributed with the runtime, there are
several options.

Larry Linson
Microsoft Access MVP