Hi

I've encountered a strange and annoying problem :

I have a large DB with hundreds of users. almost all of them are using it through the web (html).

I've made some modification to the DB to enhance web capabilities...

It is working perfectly..sometime...

Once in a while the users suddenly get a "access restriction" error message, and when I go and check the FMPU,

most of the menu objects are suddenly greyed out....so...I restart FMPU and again it is working fine...for a while..

Any ideas what could be the cause to it??

I have had similar problems when a user performes a large search and the user cancelled the action before filemaker was finished processing. In filemaker it looked like the password used on the server to start the databases was overruled by the password I set in the websecurity database.

I am not sure it is the same problem. I also did not find a solution nor a workaround yet, so I hope this info helps. I even tried a remotely triggered script to close and reopen the database by means of a "reset" but it only works when I do it manually on the server.

Wouter

Hi

Tnx for the tip....I'm not using the security DB..I'm using the built in acces privileges.

So basicaly if FMP gets "confused" it is going down to the lowest password in the "file -> access privileges -> passwords" list. is that correct?

if so then the simplest solution will be to make the lower password with the minimum setting for editing and browsing records...

Or would it go automatically to "no access at all" no matter what is in that list....??

Any other suggestion?

Well, I'm glad to say that it worked...when FMPU gets "confused" it's going down to the lowest (weakest) access privileges automatically in my case it is the "no password" password...

I've modified the "no pasword" to enable edit and browse records, and now it is working.

But i'm sad to say that for someone who need tighter security..this sucks

This is a major bug and it doesn't matter if you use FM built-in security or the security DB...

Does FMI knows about this? how come so few people encounterd this bug?

FMPU is used all over the world serving as web engines, and almost no one encounterd this bug??!!

I posted this before in databases.filemaker but got no respons. I basically have the same workaround that you use. Maybe someone else has a bright idea...

Wouter.

"I have a large DB with hundreds of users. ALMOST ALL of them are using it through the web (html)."

Have you tested for simultaneous peer-to-peer / web client actions. It is important to remember that unlike the peer-to-peer client the web client interacts in a stateless manner.

For me the problem happens with just one user (me) accessing the database over the web. No peer-to-peer access is allowed. The database itself is about 50000 records big and there are recordlevel access restrictions that force the database to do a find even when all records are displayed.

This leaves the option open for this problem to occur even when just one user goes to a listview and cancels before it is displayed.

Wouter