To make a stand alone executable, you need to use Visual Basic, Visual C++,
or other programming language. There is a runtime version of Access that you
can use to distribute your application. It will install most of Access on
the users computer, but it will only run your file, it won't let them make
design changes. Another option is an MDE version of your file.
To get the Access runtime, you need to purchase the Developer Edition of
Office (2002 and older) or the Developer Extensions in Access 2003.
http://support.microsoft.com/default.aspx?scid=kb;en-us;842004