ASP/Access Bizarre db results ?

[Matt Pegg]

Hi all,

I have a problem where I have a webpage accessing data in an MS Access database, but the results of a: set rs=conn.execute(sql_statement) appear to be cached somewhere..

Its only a recent issue, and the page has been in use for quite a while now without a problem, and I haven't touched the db connection code.

Now, however, I get results from the table as they were entered two days ago, not the current data.

I've gone so far as to remove the database altogether (to intentionally break the page) but it still loads with the old data...from where I don't know.

I've checked the db paths etc, and any other visual changes I make to the page are picked up... its just the data thats old.

Can anyone tell me whats going on ??

cheers,
Matt.

[jhardman]

Are you connecting with a file path or with a DSN?