by hi,
i have an application with an access97 frontend linked (linked tables)
to an SQL-Server 6.5 SP4. in this application, there are a lot of froms
based on queries. the login to the sql-server is coded, so all users use
the same sql-server login, different user-rights are handled by
access-users (the backend migrated from an access-solution to
sql-server). so, the user never has to login to sql-server. BUT in some
circumstances he has to do: we have tho forms based on the same query,
the one schowing an overview, the other showing all fields. the
detail-form can be started directly, all works fine. the overview-form
works well too. the detail-form can be started from the overview-form,
in this case the user is asked for the sql-server-login and password. if
he logins correct, he's never be asked later. this appears only, when
the query is run twice at a time, i can reproduce it by opening one of
the forms and then opening the query direct.
please tell me, whats going on and how to work around the problem.
klaus
--
--------------------------------------------------------
Siemens Nixdorf Informationssysteme AG
Heinz Nixdorf Ring Voice : (+49) 5251 8-14956
D 33094 Paderborn Fax : (+49) 5251 8-14902
X.400: de;dbp;scn;sni;pdb1;s1;;;Rammig;Klaus
---------------------------------------------------------