odbc parameter missing source column???

[Marco Martin]

Hi group,

I have an app that accesses an Access DB. We are using odbc because this
app will probably be using other databases as well dependiing on the clients
needs.

Consider the following;

OdbcParameter prmID = new OdbcParameter(" ID", OdbcType.Text);//ID column is
Primary Key
prmID.SourceCol umn =
myStronglyTyped Dataset.Records Table.IDColumn. ColumnName;// ds created using
drag/drop from Server explorer in vs2003
myDataAdapter.A dd(prmID);
myDataAdapter.M issingMappingAc tion = MissingMappingA ction.Ignore;//I use
this to get a less 'generic' error or else I get "Restricted Data Access
Violation" error from ODBC - Access driver ???
myDataAdapter.U pdate(myStrongl yTypedDataset.R ecordsTable);

This gives me
My Access Database column is of Type Text(50)
myStronglyTyped Dataset.Records Table.Rows[0] holds "asdf-ghjk-qwer-tyui";

For some reason I get a "Missing SourceColumn Mapping for 'ID'" error. I've
checked and double checked. My parameters' source column is set properly
inside my parameter and my table has valid data. Since this is ODBC i
thought maybe the mapping types didn't match Access's so I tried using
another type of ODBCTypeText, .Varchar, I even tried DBType.String but to no
avail.

Does anybody have any ideas of what might be causing this? Could it be an
Access 2000 problem? ODBC? Any help would be appreciated.

Regards,

Marco