Once in a minute?

[spyder]

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

[Curry]

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.

[spyder]

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