get the tables names from mdb file
-
I want to get tables Name in a Access (mdb) file and my quary is "select * from msysobject where type = 1 and flags = 0" but the exeption with the text " Records can not be read ; no permision on'msysobjects'" has happend please help me about this problem .
-
I want to get tables Name in a Access (mdb) file and my quary is "select * from msysobject where type = 1 and flags = 0" but the exeption with the text " Records can not be read ; no permision on'msysobjects'" has happend please help me about this problem .
hi, use following code here cnn is connection object
Dim Schema As DataTable = cnn.GetOleDbSchemaTable _ (OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) For Each row As DataRow In Schema.Rows If Not row.Item(2).ToString.StartsWith("~") Then Me.ComboBox1.Items.Add(row.Item(2).ToString) End If Nexthope this helpsRupesh Kumar Swami Software Engineer, Integrated Solution, Bikaner (India) My Company