-
Here is the Problem that I am having:
There is an Access Database on a IIS server with a DSN set up For it.
I have an ASP page that "gets" data from the database. The Problem is that it only gets the data once. Then, I have to wait 1 minute ( or whatever the database reset time is ) before I can retrieve the data again ( refresh the page )
I know that it is Something with the way that the database is being closed. I am Using the usual
RSData.Close
RSdata = Nothing
DBObj.Close
DBObj = Nothing
as My last lines. Anybody have any Ideas??
Thanks in advance
Devin
-
You should open the Access database.
Go to
Tools-->Options--Advanced Tab
Change the refresh interval in sec. from 60 to 10 seconds.
This should work.
-
It turned out that our SA ( DBA ) Goofed on setting up the DSN. So, it wasn't my Code after all ( Thank god :-)
Once the DSN was recreated the right way, everything worked great.
Thanks to all that Checked this out and thought about it
Devin