OK, I think I'm having a breakdown coverting my app to using views. My EXE runs fine in the development environment when a SP Function is called to NextMax() to return the next PK for the table. However, I copy the EXE to a separate folder with the Runtime files and run it and it fails. If I place "OPEN DATABASE mydbc" in the LOAD of the form it works fine. I have views in the DataEnvironment of the form and they open fine. I even added the SP to the Local DBC and it still failed.
I don't understand how the same EXE works in the dev tool but not as a standalone run time. I also CLOSE DATABASE ALL in the dev tool including my project prior to runnint it.
Any ideas?
TIA