I am trying to access the MSysObjects table in an MS Access db, but I keep getting an error
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysObjects'
How can I access this table?
It is a db without security and I am admin on computer so access should be granted.
Accessing MSysObjects
Hello,
This problem is connected with default security settings for system tables of MS Access. If you are using *.mdb file, then you will be able to change security settings in the following way:
Tools -> Security -> User and group permissions
and set 'administrator' access for the needed tables. If you are working with the *.ACCDB file, you will not be able to change access to the system tables, because in these are the restrictions for these types of files.
This problem is connected with default security settings for system tables of MS Access. If you are using *.mdb file, then you will be able to change security settings in the following way:
Tools -> Security -> User and group permissions
and set 'administrator' access for the needed tables. If you are working with the *.ACCDB file, you will not be able to change access to the system tables, because in these are the restrictions for these types of files.
OK - that has never been a problem from VBA so I didn't think of that.
The reason for accessing the table is that it is an easy way for finding tables/queries/reports in the file
I use Access for this project because I have to make some nice reports and they are easy to build in Access and if there is installed Access on the computer running the app it is possible to print the reports from Delphi, so I don't need FastReports. One has to be financial responsible in these hard times.
TNX for the hint.
The reason for accessing the table is that it is an easy way for finding tables/queries/reports in the file
I use Access for this project because I have to make some nice reports and they are easy to build in Access and if there is installed Access on the computer running the app it is possible to print the reports from Delphi, so I don't need FastReports. One has to be financial responsible in these hard times.
TNX for the hint.