Solved: VB6 - set 'read' property for MS Access table?

[andrew93]

Hi

I have an application in VB6 that links to a local Access database. I need to change the 'Read Data' property for one of the tables within the database and cannot work out how to do this using VB6.

I can do this manually like so : within Access, click Tools > Security > User and Group Permissions > select the table > tick or untick the 'Read Data' property. However, I need to be able to do this from within the VB6 application.

Does anyone have any suggestions how to do this using VB?

I'm currently using DAO to connect to the database but if I have to change that to ADO to achieve this, then that would be ok.

TIA, Andrew

Late edit : I also posted this same question on another forum here : http://www.mrexcel.com/board2/viewtopic.php?p=1122748

and for clarification purposes, I have read/write access to the database - I want to get 'Read' access to one of the hidden Access tables (ie MSysObjects).