Please help. Problem with refreshing data.

I have a VB6 application that gets its data from an Access database. It uses a join of several tables to get the information. I used a dynamic cursor and adUseServer for cursor location, but the application does not return new records that have been added to the database (the records have been added by opening Access, not thru VB). How do I get it to refresh the recordset to show all the records, not just the ones it returned the first time it was run?

Try Closing the RecordSet and Connection object and Dim another right after. The new connection obj will read the db in it's current state. This is the way I've seen it done more than any other way.

P.S. This is using ADO to ODBC in code insted of an ADO object on the form. I don't know about DAO