Solved

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

Posted on 2001-06-19
5
175 Views
Last Modified: 2008-03-06
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?
0
Comment
Question by:jeebeedoo
  • 3
5 Comments
 
LVL 6

Accepted Solution

by:
PsychoDazey earned 200 total points
ID: 6208194
There is a Refresh Method built into Access, it is collection.refresh
The problem is it will only work on things like tables and forms, not recordsets or databases.
There is also a requery method with the same basic syntax.
0
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6208209
To expand on my earlier comment: it really depends on what you want to refresh and if it is a multiuser environment.
0
 
LVL 1

Expert Comment

by:CJHarrap
ID: 6209076
if you are using an ADO recordset, there is a requery method of the ado recordset object.

Cheers,

CJ.
0
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6210165
Yes, that is the requery method I referred to in my first comment.
0
 

Author Comment

by:jeebeedoo
ID: 6211495
I had forgotten to put a me.refresh on my form...

Thanx PsychoDazey!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question