Hi to all,
first I want to say that I really am glad to found this forum.
I got some problems with queries. Following situation:
I created some queries and stored them. These queries are used in one of my function I programmed.
The db is secured by the workgroup file. I've got admin rights. When I'm logged in as admin everything's perfect and running as I want it. But when I'm logged in as another user who is not admin the queries return no records. So I granted this user every right he needs to open and read the tables used in my queries. Additionally each query I created has got "with owneraccess option" but obviously this option does not its job.
What do I do wrong?
Any help is appreciated.
Thanks in advance
TinyTin
first I want to say that I really am glad to found this forum.
I got some problems with queries. Following situation:
I created some queries and stored them. These queries are used in one of my function I programmed.
The db is secured by the workgroup file. I've got admin rights. When I'm logged in as admin everything's perfect and running as I want it. But when I'm logged in as another user who is not admin the queries return no records. So I granted this user every right he needs to open and read the tables used in my queries. Additionally each query I created has got "with owneraccess option" but obviously this option does not its job.
What do I do wrong?
Any help is appreciated.
Thanks in advance
TinyTin