Problem with query using linked tables and vba function

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have the following problem:

I have a select query which uses two tables linked to SQL Server via ODBC.
When I run it for the first time, I get the SQL Server login prompt (which
is normal, since I didn't persist the login information when I linked the
tables). The problem comes when I browse the results. Access randomly shows
the login prompt again. One of the fields within the query is calculated via
a vba function, and if I cancel the login, I get a vba error. If I debug the
error, the code window shows the vba function I was talking about, and the
execution is stopped in a line where I try to open a recordset. If I follow
the execution step by step from there, everything goes fine and I can even
resume the execution. Then, for some time, the query is run until the login
prompt appears again. By the way, I'm trying to open the recordset via dao.

Thanks in advance.


.

Relevant Pages

  • Re: Statistics and Index Choice
    ... > But I'd like to know that if I/O cost is important for execution plan, ... > SQL server able to estimate the I/O cost before executing the query? ... Index search. ...
    (microsoft.public.sqlserver.server)
  • Re: Statistics and Index Choice
    ... > But I'd like to know that if I/O cost is important for execution plan, ... > SQL server able to estimate the I/O cost before executing the query? ... Index search. ...
    (microsoft.public.sqlserver.server)
  • Re: Unusual Query Behavior for View
    ... > When we execute the query that should return a single row from ... > activity except the query execution and creation of the result set. ... > faster dual processors and about 8Gb of RAM. ... > potential bug in SQL Server running on a dual processor system, ...
    (microsoft.public.sqlserver.server)
  • Re: Frustrating Execution Plan Analysis
    ... >I've always been under the impression that Query cost is directly related to ... But if the execution plan isn't making sense, ... SQL Server will make a plan based on assumptions about what will ...
    (microsoft.public.sqlserver.programming)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)