ACCESS ADO

no luck! can you be so kind and test this on my attached example? many thanks

perhaps no, when i change my code to refer to table "Groups", i get this error: - No value given for one or more required parameters. - Exactly for this line: - Dim Dr As OleDb.OleDbDataReader = Dc.ExecuteReader - I have changed the Table name, no luck! please help me:(

Hi all, I have a very strange problem with accessing and reading from my access database. my .mdb file is password protected, the pass is "12345". ok, the code works fine when I want to read data from Table "SC" but when I want to read the data from Table "Groups" I cannot!!! you simply can replace this code with the one is my form_load event: and will see that it won't work anymore! pleassssseeeeeeee help meeeeeee! :( Dim STrPath = System.IO.Directory.GetCurrentDirectory & "\0.mdb" Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source='" & STrPath & "';jet oledb:database password=12345") Dc = New OleDbCommand("Select * from Groups where GroupName<>null order by name asc") DB.Open() Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Information, "") End End Try Dc.Connection = DB Dim Dr As OleDb.OleDbDataReader = Dc.ExecuteReader GroupComboBox.Items.Clear() While Dr.Read GroupComboBox.Items.Add(Dr("GroupName")) End While DB.Close() MyProblem.zip