The ODE(2K) tools will let you take an .mdb or .mde and distribute it in runtime. On installation, it will detect the presence or absence of Access2000 and, if needed, install the runtime. (One advantage of the .mde over the .mdb is that it is not as susceptible to end-users making changes, and the source code is stripped out.)
A few caveats:
-ODE isn't cheap
-Runtime is less forgiving than .mdb (requires exacting error trapping/handling, etc.)
-Distribution includes some IE5 functionality and a very small .mdb (i.e. 1meg) can easily exceed 150meg on a runtime distribution package
-A bunch of other stuff
Regards....