You cannot convert an Access database to become an
executable. If you think about it, even with VB / VC
executable, you still need an MDB (or some equivalent
database) for data storage.
An Access database ALWAYS needs MSAccess.exe to run the
database. This MSAccess.exe can either be a full-license
version or a run-time version.
The ODE 97 allows you to create an installation package to
install the run-time files with your database so that
users without the full-license Access can run your
database. ONLY the ODE 97 licenses you to distribute the
run-time files royalty-free.
However, it is not easy to get a copy of the ODE 97
nowadays since Microsoft stopped supplying ODE 97 when
O2K0 came on the market and the ODE was replaced by the
MOD 2K0 (and later 2K2). You can try the second-hand
market or old-ware sites but be beware of the pirated
copies.
HTH
Van T. Dinh
MVP (Access)
