Just to be clear - You can log into the database with FileMaker to perform actions but not through your Web Direct solution?
Can you confirm your privileges have database access through web direct? This is found in Manage > Security
That is correct - Both databases show the two checked. This is even happening on [Full Access]. I feel like I am going crazy.
I was mistaken, It has the same issue on both FMP and Web Direct. I had not fully closed FMP and tried again. I am attaching a link to a video to hopefully help http://youtu.be/4SNOzpmUlhc (this video was processing with You Tube as of 11:35 EST. If you can't see it, please come back.)
After many attempts, I finally figured this out. My database was opening on a landing screen with a login button. This layout was related to a TO on the back end database. As the application opened, it was logging into the back end as guest. I had given guest read permissions on the TO that supported the landing screen. When the re-login script ran, it did not update the credentials for the back-end database thus pulling over guest read only credentials.
I created a Table in the front end database with a series of global fields and linked this to the landing page. By doing this, I prevented the app from calling the back-end database until after the re-login thus sending correct credentials to the back end database.
I have also updated my guest security in the back end database to no access.