Hi guys,
I have a secured database in XP, I have created a form that sets a querydef (based on a bunch of criteria), but on this line of code the routine stops and produces an run time error:
Set qdfTemp = dbs.CreateQueryDef("parameterquery", strSQl)
The error is a 3003 - 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 a sys table named 'msysTables' - so therfore cannot adminsster rights for it...
Am I missing something obvious ?
Any ideas .....cheerz
I have a secured database in XP, I have created a form that sets a querydef (based on a bunch of criteria), but on this line of code the routine stops and produces an run time error:
Set qdfTemp = dbs.CreateQueryDef("parameterquery", strSQl)
The error is a 3003 - 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 a sys table named 'msysTables' - so therfore cannot adminsster rights for it...
Am I missing something obvious ?
Any ideas .....cheerz