Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2005
    Posts
    87

    Unanswered: Error: applying filter

    I get error when i try to open form which has on its load_event filter enabled ("fieldx = currentuser")

    Error 7752: "can't apply filter because all records are locked"..

    what could be wrong?

    thanks

  2. #2
    Join Date
    Feb 2006
    Posts
    56
    there are a couple of things that pop into mind: first,another user has access to that table/query or a query or table is opened by another process.

    Second, the database is set to exclusive instead of shared mode. only things i can thing of.

  3. #3
    Join Date
    Nov 2005
    Posts
    26
    Third: record lock (form properties) is set to locked

  4. #4
    Join Date
    Feb 2006
    Posts
    56
    absolutely correct. I forgot about that one.

    Thanks,

    John

  5. #5
    Join Date
    Feb 2006
    Posts
    56
    also another one: if the form state is set to add mode, you cannot apply a filter to the form.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •