Problem with Pass Through query and subform

[Guest]

I just switched the record source of several queries from tables linked via
ODBC to a pass-through queries. I did this so that the user won't et a
log-in prompt each time the access a query linked to the ODBC table. The
pass-through queries to the same tables have the log-info contained in them.

My problem is that I get an error message on one of my orms that says you
can't use a pass-through query as a subform/subreport. I don't get it?
What's the difference and how do I get around it?

Thanks!

 

[[MVP] S.Clark]

Welcome to Hell. Can you switch to an ADP?

If not, then you can write the data to a temp table and base the form on the
temp table. I think in 2003 you can base a form on a recordset.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Guest]

Well at least I know I'm not nuts. Since I don't know what ADP is, I'l
answer no.

I could set-up a macro to create temp tables... what a pain.

 

[Rick Brandt]

Well at least I know I'm not nuts. Since I don't know what ADP is, I'l
answer no.

I could set-up a macro to create temp tables... what a pain.

This is not required to fix the original problem. When you create links you
have an option to save the password as part of the link definition.
Alternatively you can prompt for the user name and password at startup and
loop through all the tabledefs appending that to the connect property of
each one. Then they will only need to provide their credentials once per
session.

 

[Guest]

Really? Well that would work but I can't seem to figure out how to do it.
When I link to the ODBC system datasource, it never gives me the option to
store a user name and password as part of the link. How do I do this?

 

[Rick Brandt]

Really? Well that would work but I can't seem to figure out how to
do it. When I link to the ODBC system datasource, it never gives me
the option to store a user name and password as part of the link.
How do I do this?

You should be prompted for your own credentials when you create the link. Then
at the end of the process you should be asked if you want to save the password.
This feature can be disabled on the server though.

I use the method of looping through the TableDefs as that is the only way for
the *User's* credentials to be applied instead of the developer's.

 

[Guest]

I am prompted for my credentials. I'm not give the option to store them.
I'll discuss this my network admin.

thanks Rick.