Problem with query using linked tables and vba function

J

jman

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top