Access Caching data?

[joe_g99]

Hi,

I have a bit of c# code that needs to pull data fro a database, the
problem I have is that once I have run the query once get the same
data, regardless of wether I add update or delete the data in between
calls, annoyed by this I created some simple test code with a simple
database that has 1 table with 2 columns, tableId and Value, the code
is as follows

OleDbConnection cn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=test.mdb;User Id=admin;Password=;");
cn.Open();
OleDbCommand com = cn.CreateCommand();
com.CommandText = "SELECT TOP 1 Value FROM TEST WHERE TableID =0";
textBox1.Text = com.ExecuteScalar().ToString();

And this still fails, I dont think this is a code issue though, I have
a reasonable amount of experience with access and have never had this
problem before, the only difference I can think of is that I recently
reinstalled my OS and installed a trail version of 2003 so I think it
is more likely to be a configuration issue.

Anyone got any ideas how I can get this working?

[Larry Linson]

I really don't do any ADO with Jet -- DAO is the native language of Jet and
it just doesn't make sense to "go the long way 'round". In fact, the only
time I use ADO is when I perform maintenance or implement enhancements on
ADP databases done by someone else. So, I wouldn't even venture to guess
about ADO's caching characteristics.

However, assuming that TableID is your numeric unique identifier field, then
you will retrieve the same identical record each time you execute that
SELECT statement. The TOP 1 has no effect on a SELECT that returns just one
record, and always the same one, as yours appears to do.

"Value", BTW, is not a good choice for a Field Name. It is an Access
reserved word and can cause confusion.

Larry Linson
Microsoft Access MVP
<jo*****@yahoo.co.uk> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

Hi,

I have a bit of c# code that needs to pull data fro a database, the
problem I have is that once I have run the query once get the same
data, regardless of wether I add update or delete the data in between
calls, annoyed by this I created some simple test code with a simple
database that has 1 table with 2 columns, tableId and Value, the code
is as follows

OleDbConnection cn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=test.mdb;User Id=admin;Password=;");
cn.Open();
OleDbCommand com = cn.CreateCommand();
com.CommandText = "SELECT TOP 1 Value FROM TEST WHERE TableID =0";
textBox1.Text = com.ExecuteScalar().ToString();

And this still fails, I dont think this is a code issue though, I have
a reasonable amount of experience with access and have never had this
problem before, the only difference I can think of is that I recently
reinstalled my OS and installed a trail version of 2003 so I think it
is more likely to be a configuration issue.

Anyone got any ideas how I can get this working?