none
MS Access SQL Query taking forever to run RRS feed

Answers

  • Hi,

    Looks like you may be linking to a SQL Server. Depending on your needs, you might consider either using a passthru query or creating a View?

    Do you have a persistent connection to the backend?

     

    • Marked as answer by cdtakacs1 Thursday, September 6, 2018 2:38 PM
    Wednesday, September 5, 2018 5:02 PM

All replies

  • Hi,

    Looks like you may be linking to a SQL Server. Depending on your needs, you might consider either using a passthru query or creating a View?

    Do you have a persistent connection to the backend?

     

    • Marked as answer by cdtakacs1 Thursday, September 6, 2018 2:38 PM
    Wednesday, September 5, 2018 5:02 PM
  • Hi,

    A persistent connection is something you establish as soon as the database starts up. It could be an open recordset object or a bound form (visible or hidden). You would want the object or form open the entire session.

    Hope it helps...

    Wednesday, September 5, 2018 5:14 PM
  • FROM dbo_Tak_Tempo_activities_vw LEFT JOIN Project_portfolio ON dbo_Tak_Tempo_activities_vw.[ActTaskCode] = Project_portfolio.[Name];

    Hi cdtakacs1,

    Does it help if you define a (alternate) key on the field  Project_portfo;io.[Name]?

    Imb.

    Wednesday, September 5, 2018 5:29 PM
  • Does it help if you define a (alternate) key on the field  Project_portfolio.[Name]?

    ...

    Hi There, what do you mean by this? Sorry, I'm quite new to SQL.

    Hi cdtakacs1,

    It is not SQL, it is a table/field definition. Is the field  Project_portfolio.[Name]  indexed? If not, try to do that, and sees if it helps.

    Imb.

    Wednesday, September 5, 2018 9:22 PM
  • Any other options? Thanks!

    Hicdtakacs1,

    Not so much, but perhaps some wild ideas.

    What I can think of is that the "owner" of the table "Project_Portfolio" makes an index on "Name".

    Perhaps you can make a copy of the table, index it on Name, and use that table in the query.

    Imb.

    Thursday, September 6, 2018 11:42 AM
  • Hi,

    Congratulations! Glad to hear you got it to work. Good luck with your project.

    Thursday, September 6, 2018 3:41 PM