Hi guys,

I wonder if you could help?

I've just replicated my database into master and replica databases. Now I'm retesting my vb.net application (it uses some of the framework of Beginning VB.NET Databases).

I'm running some code that uses an 'insert' query and now I get the following error message:

Number of query values and destination fields are not the same

Here's the query code:

objData.SQL = "INSERT INTO [FitnessTestHistory] " & _
   "VALUES(@ID, @DATEOFTEST, @VESSELID)"

objData.InitializeCommand()

objData.AddParameter("@ID", OleDb.OleDbType.Guid, 16, guidCrewMemberID)
objData.AddParameter("@DATEOFTEST", OleDb.OleDbType.DBDate, 8, DateTime.Parse(txtDateOfTest.Text))
objData.AddParameter("@VESSELID", OleDb.OleDbType.VarChar, 5, txtVessel.Text)

objData.OpenConnection()

intRowsAffected = objData.Command.ExecuteNonQuery()

MS Access automatically added the following fields to each table when I did the reputation:

s_ColLineage
s_Generation
s_GUID
s_Lineage

Are these the problem? Can anyone tell me what is going on? Thanks in advance.

Well, I've managed to sort out a work around answer folks.

Instead of hard coding the "INSERT INTO [tablename] part of the SQL statement, in my Access table, I created parameter query and then called the parameter query from the SQL object.

This seems to work.