ASP/Access Bizarre db results ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Matt Pegg
    New Member
    • Apr 2007
    • 5

    #1

    ASP/Access Bizarre db results ?

    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
    Recognized Expert Specialist
    • Jan 2007
    • 3405

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

    Comment

    Working...