Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2002
    Posts
    10

    Angry Unanswered: Any1 know a workaround for msysTables security issue !!!

    Hi guys,


    Here's my problem..

    I have a secured database in XP, I have created a form that sets a querydef (based on a bunch of criteria), if I run it with Admin rights everything is fine, but if i run it with one of my users id's i get an error and the code stops. I have assigned permissions for these users to create new queries but to no avail. The line of code that stops is as follows:

    Set qdfTemp = dbs.CreateQueryDef("parameterquery", strSQl)

    The error is a 3003 (run time) - security issue refering to no permission to use 'msysTables' object, I have set the options so all system/hidden files are displayed, I dont have see a table named 'msysTables' - so therfore cannot administer rights for it...

    Am I missing something obvious ?

    Any ideas cheerz

  2. #2
    Join Date
    Mar 2002
    Posts
    10
    Note:

    I have also given these users access to read and modify Query objects (as suggested in a previous post) but to na avail

  3. #3
    Join Date
    Mar 2002
    Posts
    10
    No advances on this ?

    (sorry for re-post!)

  4. #4
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    22
    Was the workgroup file from an older version of access? I had a this problem when converting from access 2.0 to XP. In the end I had to completly de-secure the database and create a new workgroup.

  5. #5
    Join Date
    Sep 2001
    Posts
    46
    ecynaxt,how to de-secure it.

Posting Permissions

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