Results 1 to 6 of 6
  1. #1
    kd11 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2015
    Posts
    3

    Run-time error '2580'


    We have an application written in Access 2010, which go out to the database (SQL 2005) and retrieve information that was given, all of a sudden if you enter in a name and hit the Search button that produces an error message "Run-time error '2580': The record source <XXXX> specified on this form or report does not exist." However, when I look in the database the <XXXX> does exists and I'm able to run the stored procedure without any issue? I've done a repair to Access and that didn't help. What could be the issue and how to fix it, I would appreciate any suggestion. Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    What are you using to retrieve the data? docmd.Openquery?
    other?

  3. #3
    kd11 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2015
    Posts
    3
    That is correct, docmd.Openquery is being used

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    It may have lost its link. Can you 'reload' the stored proc in Access? (basically create it again)
    this may refresh the link.

  5. #5
    kd11 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2015
    Posts
    3
    Do you mean recompile the stored proc? how do I go about doing that, I'm not an Access guy.

  6. #6
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I think he means name the query "qryYourQueryOLD", switch to sql view, copy the sql and dump it into a new query with the original name. However I suspect your problem is elsewhere given that you can run the query directly. It sounds to me that something in the relationship between the form or its code is not in sync with the query.

    In the OpenQuery call, you may have mis-typed the query name. Or a recordsource or rowsource property (if you are using them) is not the same as the name of the query or field you are trying to use. Post the name of the query and some code around the part where you call it. Best to copy and paste object names (queries, tables, etc.) where applicable to avoid typos. If it is easier, you can post a zipped copy of your db for analysis of the issue.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 05-01-2014, 11:56 AM
  2. Replies: 3
    Last Post: 01-23-2014, 07:49 AM
  3. Replies: 3
    Last Post: 03-05-2013, 11:17 AM
  4. Replies: 0
    Last Post: 07-16-2012, 05:42 AM
  5. Replies: 6
    Last Post: 05-30-2012, 12:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums