And a final note, you should encrypt the password stored in the exe. The encryption doesn't have to be the strongest, possibly just even an ascii value shift, but atleast some level of encryption that will keep someone using a hex editor from noticing an unusual string of characters in plain english at the end of your exe.

I had write a form in a project that it will update the log number table when a click the "New Log Number" button. Everything seems OK when I run from the project!
But when I complied it to a exe and run the EXE and click the "New Log Number" button, an error message come out and the content is somthing about "cannot update the temp table"?

Make sure that you did not include the table with the exe, (you can not update a table built into the exe). That should fix your problem.

I have generated an EXE on the server then a shortcut in local drive C:\ . This shortcut starts in C:\MyDocuments (anyfolder). I'm trying to read a file located at the same place as the EXE so I need to get the full path name of the EXE.

The exe name is NOT the project name: they are two different things. As soon as you save your project (after building an exe), whatever you built as your exe is the name it will always use for the exe. You can change the project name and it doesn't affect the exe name.

Exe

Meaning

Noun

Name

Related