Last post Aug 08, 2007 11:59 AM by moizdhanji
Mar 27, 2006 11:45 AM|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 01:59 PM|deokule2003|LINK
Mar 28, 2006 05: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 08:03 AM|deokule2003|LINK
Mar 28, 2006 10:39 AM|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 02:06 PM|deokule2003|LINK
Aug 02, 2007 10:40 PM|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 11:59 AM|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