open access 2007 only when called by executable file

[rommelgenlight]

I have created an executable file that will load my access project.

What I want to know what code to use in Access that will not continue to load itself when it is not called by the executable file.



my design would be, the executable file is the only file that will load the access project (FE). and after the access project (FE) is loaded, the executable file will unload and end itself.

therefore, when I double click the access project (FE), it will not continue to load itself and it will quit especially when it is not called by the executable file.

I found my answer. but basically I think its not that good but for me it works.

What I have done is I made a procedure that checks the existence of a file and a registry key. when it is not there, Access will quit.

Only the executable file will create that file or registry key. and the file and key will be deleted when after access is loaded, logout or quit.

That's my simple solution for that.

I know it has potential issues especially on abrupt computer shutdown or improper exit.

Can some assist here please.

[llkhoutx]

I wouldn't use a registry key, abnormal terminations of an Access program is quite common. The mere existence of a file is a sufficient test.