Access 2007 or Access 2003 Question

[Guest]

I just purchased Microsoft Access 2007, and hope to make use of an Access
Database in one of my applications. I do have a few questions though, as I
do not know if I should use an Access 2007 or an Access 2003 Database. Here
are my concerns (Which I have not been able to find answers to):

1) Access 2007 uses its own run time, which is not part of windows and would
need to be installed along with my application, correct? Where would I get
this runtime installer from? I cannot find this.
2) As Access 2007 uses its own run time, what are the system requirements
for this run time. What Operating Systems / Versions of Windows are
supported?
3) Does Access 2003 run on all versions of Windows? Would I need to (Or
should I) Include the JET Runtime with the install of my application?
4) My application requires that I be able to transfer / sync data between a
computer and a palm pilot / handheld. Does both versions of Access support
this?
5) Are there any differences with the two types of databases that would
cause issues if I try to use them with my application?

I am also interested in any additional information anyone thinks I should
know.

Thank you very much.

 

[Pat Hartman \(MVP\)]

The runtime for A2003 is a part of Visual Studio Tools for Microsoft Office
(or something like that) and is an expensive purchase for individuals. The
runtime for A2007 will be distributed at no cost. It was available briefly
a few weeks ago but there was a problem with it so it was withdrawn.
Hopefully, it will reappear soon. Keep checking the MSFT download site.

Both applications would be able to sync with the palm pilot assuming you
have the correct cables and software. A2007 is very new and not many
applications have been distributed yet to the jury is still out as far as
issues go.

If I were going to distribute a runtime engine along with my application, I
would lean toward using the platform that provided the features I needed for
development. A2007 has some excellent new features but due to the total
revamp of the UI, will cause productivity issues for development for some
time until you refamiliarize yourself with where everything is. The ribbon
still needs some work. It is always supposed to show what you need but I
find I have to switch ribbons more than I thought I would. Your application
can shield the user from the ribbon and the navigation pane (a real pain
IMHO) by using custom menus so don't let the A2007 UI influence your
decision.

 

[George Hepworth]

The 2007 runtime was re-released, as of last Friday. So far, no feedback on
furhter problems has surfaced.

George