FWIW - I changed my code to use a DataReader and it works.



>>I'm trying to return a dataset from an Access table. I have done this same block of code in other apps dozens of times with no problems
>>
>>

>>static string AccessConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Projects\Sales Quote\Database\Orig\quotedb 9-27.mdb";
>>static OleDbConnection AccessConn = new OleDbConnection();
>>
>>static void Main(string[] args)
>>{
>>    AccessConn.ConnectionString = AccessConnString;
>>
>>    try
>>    {
>>        AccessConn.Open();
>>    }
>>    catch (Exception e)
>>    {
>>        throw e;
>>    }
>>
>>    OleDbCommand oCmdVendors = new OleDbCommand();
>>    oCmdVendors.CommandText = "select * from quote";
>>    oCmdVendors.Connection = AccessConn;
>>
>>    OleDbDataAdapter AccessDA = new OleDbDataAdapter();
>>    AccessDA.SelectCommand = oCmdVendors;
>>
>>    DataSet dsAccess = new DataSet();
>>    AccessDA.Fill(dsAccess, "Quotes");
>>}
>>
>>
>>

>>
>>Tonight I get this message on the AccessDA.Fill:
>>
>>

>>The provider could not determine the Object value. For example, the row was just created, the default for the Object 
>>column was not available, and the consumer had not yet set a new Object value.
>>

>>
>>I have Googled this and there are not any real answers. What the HECK is this????
>
>Two guesses : some kind of lock or something having to do with Select * and a structure change on the other end conflicting with structure of a strongly typed data set. If you enumerate the fields do you get the same result?