<div>
To expand on my earlier comment: it really depends on what you want to refresh and if it is a multiuser environment.
</div>


To expand on my earlier comment: it really depends on what you want to refresh and if it is a multiuser environment.

<div>
if you are using an ADO recordset, there is a requery method of the ado recordset object.<br />
<br />
Cheers,<br />
<br />
CJ.<br />

</div>


if you are using an ADO recordset, there is a requery method of the ado recordset object.

Cheers,

CJ.


<div>
Yes, that is the requery method I referred to in my first comment.
</div>


Yes, that is the requery method I referred to in my first comment.

<div>
I had forgotten to put a me.refresh on my form...<br />
<br />
Thanx PsychoDazey!
</div>


I had forgotten to put a me.refresh on my form...

Thanx PsychoDazey!

<div>
<div class="content wysiwyg-content">
This is the setup I have:<br />
One MS-SQL 7 database exporting data to my access file through a service every 2 minutes. &nbsp;But if my access file is opened and data is exported to it, then I need to close and reopen my access file in order to view the newly exported data.<br />
<br />
Thus, my question is how can I refresh my access file with the newly exported data without having to close and reopen it?
</div>
</div>


This is the setup I have:
One MS-SQL 7 database exporting data to my access file through a service every 2 minutes.  But if my access file is opened and data is exported to it, then I need to close and reopen my access file in order to view the newly exported data.

Thus, my question is how can I refresh my access file with the newly exported data without having to close and reopen it?

How do I refresh data imported from a service without closing and reopening my access file

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.