Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

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

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
jeebeedoo
Asked:
jeebeedoo
  • 3
1 Solution
 
PsychoDazeyCommented:
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
 
PsychoDazeyCommented:
To expand on my earlier comment: it really depends on what you want to refresh and if it is a multiuser environment.
0
 
CJHarrapCommented:
if you are using an ADO recordset, there is a requery method of the ado recordset object.

Cheers,

CJ.
0
 
PsychoDazeyCommented:
Yes, that is the requery method I referred to in my first comment.
0
 
jeebeedooAuthor Commented:
I had forgotten to put a me.refresh on my form...

Thanx PsychoDazey!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now