• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2805
  • Last Modified:

Auto refresh sql table link in ms access xp.

Dear EE members,
I have a link table in ms access, where it links to ms sql table in remote site via odbc.
Currently, my access application is running by scheduling the macro and batch file, which
grab data from remote database and process in current win2k server.
I would like to auto refresh the link, before I launch the access application and process data.
Any way to do this?

Regards,
Peter
0
peter_chong
Asked:
peter_chong
  • 4
  • 3
1 Solution
 
frankyteeCommented:
drop that linked table and recreate that link (via docmd object)
0
 
frankyteeCommented:
to remove:
DoCmd.DeleteObject acTable, "whatever Linked Table"

to link:
DoCmd.TransferDatabase acLink, "ODBC Database", _
    "ODBC;DSN=whateveDSN;UID=whateverUser;PWD=whateverpassword;" _
    & "DATABASE=whateverDB", acTable, "SQLTableName", "TableNameInAccess"

replace names accordingly
0
 
peter_chongAuthor Commented:
Dear EE members,

The access 's link table may cause MS Access closed. Any solution for it?

Regards,
Peter
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
peter_chongAuthor Commented:
Point added again.
0
 
frankyteeCommented:
>The access 's link table may cause MS Access closed. Any solution for it?

dont understand what you said. removing a linked table will not cause access to close.
0
 
peter_chongAuthor Commented:
What I mean is:
When I point my mouse cursor to the link table in MS Access. The Access closed itself.
Any idea?
I have connected the link via ODBC. Anything that I have missed out?

Regards,
Peter
0
 
frankyteeCommented:
peter, did you resolve the mouse cursor issue? have you tried repairing the db or importing everything into a blank db or decompile it?
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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