Error msg when trying to list MSysObjects 1

[barny2006]

hi,
i'm getting this error msg:
Record(s) cannot be read; no read permission on 'MsysObjects'
when i'm trying to list table names with this code:

commandstring = "SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],3)=" & chr(39) & "Feb" & chr(39) & ");"  
objRecordSet.Open commandstring, objConnection, adOpenStatic, adLockOptimistic

any ideas why?

 

[mrmovie]

Silly me,<br><br>I hadn't set read permissions on the msysobjects table.<br><br>Select Tools-Options-View-Show-System objects, Click OK<br>(this makes the system object tables visible)<br><br>Select Tools-Security-User and group Permissions<br>Select MSysObjects from object names<br>Add 'Read Design' and Read Permissions<br><br>My code worked just fine after that.

 

[barny2006]

thanks so much, mrmovie.
that did it. i gotta keep that in mind.
thanks again.