MsSysObject Permissions

[ccraw]

I am currently using a VB program that is trying to access the system table MsSysObjects, for linked table information.
Using DAO internally in the mdb file, I can retrieve this info without any problems. Trying to read information from this table, with my VB App using DAO, I get an error like ...Cant read from MsSysObjects...permissions not available for read.. (Can't remember complete message).

I do not have any permissions set on the current mdb file.

Does anyone have any suggestions?

 

[hermanlaksko]

MsSysObj can be odd to work with, so what I did was make a query based on MsSysobj in this I took the fields I needed and then it works every time - not sure if this will work for you in VB as I only tryed it in acceess itself, but it could be worth a try.

Herman

 

[ccraw]

If I use a query within access to append the required info, I have no problems. Once I try to access this table outside of access (Using VB), I then strike my problem.

I have even tried creating queries and tables from an external VB program (Using tabledef and Querydef), and I still have had no luck.

I hope someone can help.