Hi, I'm here again.

I have a datatable with the following columns:
UserID (pk, autonumber)
UserName (text)
RightsID (number)


I fill a dataset (DSUsers) with the values of this datatable and now I want to find a specific value of this dataset: the RightsID of the first UserID in the table.

I tried the following code:

Dim UserRights as Integer
UserRights = DSUsers.Tables("tblUsers").Rows(0)("RightsID")
But I constantly get the value '0' while it should be '2' because thats the actual value in the database.

Is my selection code wrong?

thanks

TOm