'MSysTables', where are you?

[Baffled]

Hi guys,

I have a secured database in Windows 2000, I have created a form that sets a querydef based on user criteria and produces a graph of the data. 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. The users do have permissions to create new queries.
The error is a security issue referring to no permission to use 'MSysTables' object. I have set the options so all system/hidden files are displayed. I don’t have a table named 'MSysTables' – and therefore cannot administer rights for it...Am I missing something obvious? The back up does not produce this error where it resides, when coping it to a different directory all of the object security is reset, and the users have all rights to all objects. So I re-established the security for all objects and it produces the error again. I've created a new database and imported all of the objects (from current db and from backup) into it, that didn’t work for the front end or the back end. I even created a new workgroup info. file and imported everything again into a new database and I still get the error. Also tried jetcomp.exe. I’ve looked high and low for a solution on the internet, but I have not been able to find a cause or a solution. The only thing that was suggested is that it has something to do with using querydef. If anyone can help it would be greatly appreciated!

Baffled

 

[WayneRyan]

Baffled,

Just go on Google and type in "MSysTables". There's a ton
of info...

Wayne

 

[Baffled]

Which web sites are you referring to? The only sites I have come across pertain to ADOCE and I am not working with a WinCE device nor am I referencing a WinCE library. Any other suggestions?

Baffled

 

[WayneRyan]

Baffled,

I did an advanced google search, omitting ADOCE and got this:


http://dbforums.com/showthread.php?threadid=312022

Have you upgraded recently,

I will research some more ...

Wayne

 

[WayneRyan]

Baffled,

I know you don't want ADOCE, but this was from another
Access forum. It seems that other people have encountered
this and it seems to center around upgrading/security.

http://www.tek-tips.com/viewthread.cfm?SQID=224177&SPID=181&newpid=181&page=1

According to Microsoft's knowledgebase, MSysTables is part of ADO for Windows CE 3.1. You might want to check out articles:
Q241402
Q265796
Q207562

Several access forums have no mention of this (in "our"
access environment), even the Microsoft Knowledge base.

OK, I'll stop throwing this stuff at you.

Good luck,

Wayne

 

[Baffled]

Ok this was what the problem was - I enabled the users to read design, add data, update data and delete data for the query that was driving the graph, but I did not give them modify design rights. So when the query needed to be modified per the criteria the user did not have permission to update the query design. Therefore, Access produce the error message stating the user did not have the necessary permissions for the ‘MSysTables’ object. Talk about misleading! I still don’t know what or where the ‘MsysTables’ may be, but everything seems to be working now. Any who, my bad. Thanks for all the help Wayne!

Baffled

 

[ktariske]

I thought this was a hidden system file?

Under options in Acces there is an option of hide/display system tables, ojects. ????? I thought.