Hello,

I am making an interface from VB.NET to Micro's Access. I am using an SQL statement to pull a name from a table depending on the number entered in the interface:

     select first_name from val_stu where patron_id = " & (Val(txtNumber.Text))


I get the error on the line with the code:

     OleDataAdapter3.Fill(DataSet31, "val_stu")


The error is:

     "An unhandled exception of type 'System.Data.Constraint Exception' occuered in tsystem.data.dll

      Additional information: Failed to enable constraints. One or more rows contain values violating non-null, unique or foreign-key constraints"


Does anyone know what this means and how I can solve the problem.


thanks,

lab assistant

Sorry to post all.

I figured out the problem. It was my SQL stament.

The statement should have been "select * from val_stu " not "select first_name from".

Hope my dumb mistake helps someone else out int the future.