How to fill a OleDbDataAdapter with more than 12 records from Access DB

Question

I have an app I am building that uses Access as the DB. While I am developing it, I have the DB located on a network share. I just ran into a limitation during the OleDbDataAdapter.Fill method where it is only returning 12 records. If I move the DB to the local drive, it will return the proper amount of rows. My connect string is really simple "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\filepath....\TFS_db.mdb"

Here is the section that is retrieving the records. (sqlText has the query string & RecipeTableName is the name of the table.)

using (var connection = new OleDbConnection(libRegistry.ConnectString))
using (OleDbDataAdapter dataadapter = new OleDbDataAdapter(sqlText, connection))
{
connection.Open();
ds.Tables.Add(RecipeTableName);
int rowsFilled = dataadapter.Fill(ds, RecipeTableName);
}

Is this a limitation in the OLEDB or Access? If so is there a way to work around it? I haven't been able to find anything from my searches related to a limitation.

Thanks for your help!

Answer 1

There is no limitation for a regular SELECT column names FROM SomeTable.

Unless there is a really solid reason for using .mdb move to .accdb and try with similar code to the following. See if that works or not before using a DataAdatper. Also double check your connection string is pointing to the correct database.

public static DataTable GetAll()
{
    DataTable table = new DataTable();
    using OleDbConnection cn = new() { ConnectionString = "TODO"};
    using OleDbCommand cmd = new() { Connection = cn };
    cmd.CommandText = "SELECT Id, FirstName, LastName FROM Person";
    cn.Open();
    table.Load(cmd.ExecuteReader());
    return table;
}