Last post Aug 08, 2007 04:59 PM by moizdhanji
Mar 27, 2006 04:45 PM|mariolopes|LINK
I want to populate a combobox with the name of the tables of one access database. I use the following statment
SELECT [Name] FROM MSysObjects WHERE [Type] = 1
I get stuck on the error Record(s) cannot be read; no read permission on 'MSysObjects'.
Mar 27, 2006 06:59 PM|deokule2003|LINK
Mar 28, 2006 10:13 AM|mariolopes|LINK
My access database name's english
How can write the sql statment for extract the name of all tables in that database?
Mar 28, 2006 01:03 PM|deokule2003|LINK
Mar 28, 2006 03:39 PM|mariolopes|LINK
One more question: if i want to show all the tables except the system tables (TABLE_TYPE only Table). Any ideas?
It is possible to do it with a sql statment?
Thank you a lot...
Mar 29, 2006 07:06 PM|deokule2003|LINK
Aug 03, 2007 03:40 AM|kenbati|LINK
Very good Kuldeep; On quick question. On the same lines how do one see Field names and their types? thanks in Advance
Aug 08, 2007 04:59 PM|moizdhanji|LINK
if you want to see all system & hidden tables, go to Tools -> Options -> View Tab and enable all check boxes.
if you want to assign security to Admin (or any) user, go to Tools -> Security -> User and Group Permissions and assign rights for each table.
I'm currently using Visual Studio 2008 Beta2 (Orcas) & I felt to share this info with you people.
AccessDataSource INSERT problem
Access database query string
Access Database - FileDSN in ASP.NET 2.0
OLEDB - Relative Connection string
Microsoft Access Database Delete