Problem with query using linked tables

[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.

 

[Tom Wickerath MDB]

if you have a problem with a query using linked tables, then you should move
to Acces Data Projects

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.