how to make EXE from Access

[uoghk]

I use Linked Table to connect to backend SQL database and Access as frontend.
How to make EXE so that I can deploy to client computers?
Although I setup ODBC connection on my computer to access the SQL database.
Everytime I start Access to open tables, forms and/or reports, It always are me to enter SQL database password.
How to avoid this in EXE?
Thanks.

[isladogs]

Convert your ACCDB to ACCDE if you want to protect your code.

You cannot create an EXE file direct from Access.
Use an installer program such as SamLogic Visual Installer, Inno or SSE to package your file(s) as an EXE for distribution

It sounds like you are using SQL server authentication.
Instead use Windows Authentication and you will not need to enter a password each time.

[Gicu]

Even with SQL authentication you can avoid the password prompt but you need to delete all SQL server linked tables and when adding them back make sure you click the Save Password check box on the lower left part of the wizard window (unfortunately you will get a prompt for each table). Once you do that you should be able to open it without any issues, and same for your users if they have the same ODBC driver installed.

Cheers,

[uoghk]

When I deploy the Access to end users, I setup the same ODBC for them.
Then for each linked the SQL server table, I also need to provide password at the first time.
Do you mean that?
If yes, is it possible to keep the password in a text file, when starting Access, reading this password from the text?

[Gicu]

No, I mean you need to delete the link tables you currently have, then use the External\ODBC Database and link them back using a new file DSN. After you select the driver and its options, server, database you will see the list of tables. Select all that you need then in the lower left you'll see a Save Password check-box, make sure it is checked. You will be prompted if you want to save the password for each table, answer Yes for each one. Using the file DSN basically creates a DSN-less connection so you do not need to create machine or user DSNs on each user's computer. As long as each user has the exact same ODBC driver installed on their machine they should be able to open the front-end with no prompts.

Cheers,

[uoghk]

Understand.
Thanks Vlad & Colin.