Access query works fine in the morning, stops working later in the day

I have this Access database that we use to run reports. The report is run twice a day every working day.

For some reason the report will run fine usually in the morning but every now and then it will stop working. I go to debug and it will show a different query failed to run every time.

So far there are two ways to fix this. Close the application and re-open, or refresh the linked tables. I would really like to know why this is happening and if possible how to prevent it.

The tables are connected through ODBC which points to SQL Server 2000. The error messages usually say "Could not connect to --". In between -- should be the ODBC connection name but it doesn't display.

There are about 10 linked tables. The computers are on wired LAN. If I open one of the failed queries and try to run it fails. When I refresh/reopen it works.

When I say go to debug I mean that when the error occurs it gives me two options end/debug. I click debug and it opens up the modules (VBA code) window.

-------------Problems Reply------------

usually in the morning but every now and then it will stop working

This sounds REAL familiar to me. Perhaps your company servers are so backed up at this time that your reports are giving time out errors? I recommend scheduling your reports at a different time. If your boss says No, tell him/her "Ok, It will continue to run in the morning, but it may not always go out."

Could someone be changing the definitions of the tables that are linked? If so, that might be the problem.

Category:ms access Views:0 Time:2010-09-13
Tags: ms access

Related post

  • UPDATE query works fine when run from Access, but raises SQL syntax error from within C# app 2008-12-16

    I have a very simple Update statement that will update mail server settings and network credentials info... Query works fine when I run it in Access but C# keeps giving me the error stating that my SQL Syntax is wrong ... I have a dataaccess layer (d

  • Access query returns empty fields depending on how table is linked 2009-03-05

    I've got an Access MDB I use for reporting that has linked table views from SQL Server 2005. I built a query that retrieves information off of a PO table and categorizes the line item depending on information from another table. I'm relatively certai

  • Sum of calculated field returns wrong result in MS Access query? 2011-06-24

    I have these 2 tables: Table1: CustomerID Area Type Revenue 1 Europe Institutional Clients 10 2 Asia Institutional Clients 10 3 USA Institutional Clients 10 Table2: Report Country Type Rate DK Institutional Clients 2 SE Institutional Clients 2 FI Ins

  • Export Access Query To Sharepoint List 2012-03-03

    I am attempting to export an access query to one of my sharepoint sites. I have full control privileges on the site. The process I am following is (from Access 2007 Menu), after selecting my source query, I am choosing menu items: External Date, expo

  • Excluding many special characters in ms access query 2012-01-17

    Hi. :) I am having a problem in MS Access query. I have to run a query to leave out any special characters from the column (containing many text strings) except for some. For example, in a column where there are many special characters, I have to onl

  • Refresh Access Data fails after adding DCount to Access Query 2012-04-10

    I am pulling data from an Access database Query it was working fine until I added a DCount field to the Access Query.....the Query runs fine in Access and if I remove the DCount column from my Query Excel will refresh the data. I also tried to restri

  • data in Excel external data link different from Access query 2012-06-20

    I have a select query in Access in which I determine if a parameter has a value or not, e.g., DetValue: IIf([Flag] Like "*U*",0,[Value]) . When the query is run in Access it works fine (the result is either a zero or a number = [Value]. However, when

  • Access Query Criteria Suddenly Not Working 2012-07-13

    I have a query with several SQL 2005 relational tables linked to one Visual FoxPro table in an Access database. I also have criteria on one of the Primary Keys of one of the Access tables that is a reference to a field on a form (forms!frmTruckload!m

  • Need data in Excel but Access query fieldnames change every month 2012-08-17

    I have a database that calculates data monthly for 12 months. A table is created with this data and the 13 fieldnames of the data are [Type] and [9/1/2011] thru [8/1/2012] (i.e. 12 individual months). The data (value) for Type is A, B, C, D and for e

  • word 2007 mailmerge access query 2012-10-08

    Hi all. I have a query in access that works fine. It provides info from 4 tables. The criteria is an empty 'like', so every time it is run it pops up a little window and asks me to enter the search criteria. The return is one line of data. This data

  • Merging with Access query, the query filter doesn't carry through to Word 2014-02-21

    Hello: I'm doing a mail merge between Word and Access. I'm selecting a query as a my data source. The query has a "Not Like" statement that works fine when I run the query in Access. However, when I do a practice merge within Word all my records are

  • Access query gives wrong result 2014-05-05

    I'm running a simple query against a DB2 table using ODBC. But there's a problem. I was retrieving all sorts of extraneous data, so I simplified the query so that I only pull records with an account code of say, "1234". That's it, there are no other

  • Exporting 1/1/1900 Date from MS Access Query to MS Excel 2014-09-15

    I use MS Access to record specific data for a client of my employers. There are times that we record that a milestone has been achieved but the work wasn't done by our company and in these cases we have always marked the date as #01/01/1900# so that

  • Access Query to txt file without column names. 2008-12-09

    I have an access query which creates some output, 3 columns named e.g. A, B, and C. I would like to create a function where I can automatically output this query to a text file without the header rows. I am currently outputting the file to excel then

  • How do I access query parameters in the request content body in javascript? 2008-12-23

    If I use a GET to request a page, then I can access any query parameters from javascript using Is there a similar way to access query parameters which are in the request content body rather than the request location, when the

  • Problem with a MS Access query after a "Compact and repair" operation 2009-06-09

    I have an Access application that use the classical front-end/back-end approach. Yesterday, the backend got corrupted for a reason I don't know. So I opened the backend with Access 2003 and access asked me if I wanted to repair the file, I said yes a

  • MS Access Query Designer - similar functionality using standard .NET 3.5 controls? 2009-07-16

    I would like to achieve something very similar to Microsoft Access query designer - I am talking about a plane(canvas?)-like surface on which users can place and move controls. Is this even possible? If it isn't possible with free .NET controls - the

  • How to convert access query to sql server query string? 2009-09-15

    how to converse access query to sql server query string by programing? example for access query string SELECT dbo_VNMST.VISITDATE, dbo_VNTREAT.TREATMENTCODE, dbo_VNMST.HN, dbo_VNMST.VN, dbo_VNTREAT_1.TREATMENTCODE, Count(dbo_VNMST.HN) AS CountOfHN, d

  • access query to filter and combine count 2009-11-13

    i have two access tables tableA num count 1 7 2 8 3 9 4 9 5 13 6 6 tableB num count 0 1 1 14 2 12 3 5 4 5 5 11 6 5 how can i create an access query that will ignore the numbers which have count less than 6 in any of the two tables. i.e. 0,3,4 & 6

Copyright (C), All Rights Reserved.

processed in 0.142 (s). 11 q(s)