Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Using an Access Macro to extract data from SQL database problem

Posted on 2007-10-11
Medium Priority
Last Modified: 2012-05-05
Using an Access Macro to extract data from SQL database problem.  We are using techscheduler to run this macro at specific times.  Every couple days it fails and you have to re-link the tables and then re-run it.  Any ideas what could be causing this to have to re-link the tables.  I checked maintenance tasks.

Question by:mkurtzhals
LVL 11

Expert Comment

ID: 20057582
Chances are its an issue with the SQL db. Is it getting rebooted?
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 20057604
why not include a routine that checks the link before running the macro.
if link is broken, relink using codes.

Author Comment

ID: 20057959
sample code?

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

579 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