Hlp pls. - 1 record per page, refresh through records problem

Can anyone help me with the following problem?

I have an Access DB which holds a basic "message" database;
Fields = MSG_ID, MSG_Text, MSG_Date

I would like to setup an ASP webpage that:

Connects to the database, [OK]
Displays the first record, [OK]
Refreshs / cycles through remaining records until eof. [Help!]
Starts again. [Help!]

I am sure it is possible - I am just too new to all this.

I used to have a very basic html solution using the REFRESH tag, however this used a fixed number of "records".

Thanks in advance for any help / advice anyone can give.

LS

Hi LS,
OK, What you want to do is setup a recordset and refresh this recordset every xx seconds, right?

You just forgot to mention if your using VB.NET, ASP or VB? If you can plz let me know then I can show you a working example

Thanks,

I am trying to use ASP.

The solution I am after needs to refesh from one record to the next every 10 seconds.

Looking forward to your worked example.

LS