You cannot make an .exe from an Access MDB.
("Compile" for VBA code does not create an .exe.)
If you want to distribute your MDB to users who do not have a full copy of Access on their systems you can distribute with Access Runtime license. For A2K, this license is part of Office Development Edition- now out of print/distribution, but you can sometimes find it on Ebay, etc.
HTH,
Loralee
|