Nice project. Looks well designed. Unfortunately, no. What you want to do cannot be done with Access. You can, however, have your end-users install the Access Runtime, which is free. Then you can distribute your ACCDE file and they can use it without paying for an Access license.

I don't understand what your "Unfortunately, no." refers to. Do you consider the Access Runtime to be different from Access or ???  I understand that it is technically. But unless you want users to be able to mess with the distributed application, isn't it what you would normally do? For the very few I have done, this is my approach.

My "unfortunately no" means you cannot turn an Access ACCDE file into an EXE like you could with a VB6 project. You need to have at least the Access Runtime installed.

Thanks for your reply Dan, however, I do believe Richard hit it right on the head when he said "unfortunately no" because I was aiming to create an "exe" file from Access which of course I now understand you cannot do. But the alternative Richard has provided works just fine for me. As long as the user does not have to purchase an extra license, and I can let them do the same on an Access data entry form, great!

Hello Richard:
Thank you for the compliment. Your solution is exactly what I needed because this will allow me to design a form for the user in Access and then use the Access Runtime to distribute the ACCDE file so they won't have to purchase Access to run it. Thanks so much for your input.

Here's a video I recorded a little while back about it too: Access Free