repost - security issue - access xp (vba)

[Lavey]

Hi guys, sorry if you've seen this thread in different forums, dont ususally repost...but I can't seem to get this sorted..

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

 

[Lavey]

No ideas guys ?? X-) Honest guv, i didn't do it !