Are linked table based subreport in Access possible?

[VectorRichmond]

I'm trying to insert a subreport into an Access report. Both the main report
and the subreport are based on linked-tables (from an iSeries ODBC
connection). If either report is run on it's own, they prompt me for my
iSeries User ID and password (twice), then the report works. However, when I
try to insert the subreport, it just keeps asking me for my iSeries user ID
and password, over and over (and never stops asking).

Has anyone used a linked table based subreport?

 

[Larry Linson]

I'm trying to insert a subreport into an Access report. Both the main
report
and the subreport are based on linked-tables (from an iSeries ODBC
connection). If either report is run on it's own, they prompt me for my
iSeries User ID and password (twice), then the report works. However,
when I
try to insert the subreport, it just keeps asking me for my iSeries user
ID
and password, over and over (and never stops asking).

Has anyone used a linked table based subreport?

Yes, I have. They were ODBC-linked tables in Informix, MS SQL Server, and a
couple of Sybase products. The DBA had set each of them up with a Data
Source Name, so that (1) the first use required entry of the user's password
or (2) the userid and password were included in the linking information and
never required of the user. Those are server DBs and ran on a server machine
on the LAN or WAN.

"iSeries" sounds like a mainframe to me, and you must be using some database
software on that mainframe to link the Tables -- I haven't worked with
mainframes for a good many years, so can't address how your security might
be implemented. Someone in your operation should know, and should be able to
explain what you must do to avoid getting caught up in the endless loop. The
fact that you are being bombarded with the request would lead me to conclude
that, however you are set up, each time a record in the Report is created
(and, thus, the Subreport data is retrieved and displayed) is treated as a
separate new connection to the mainframe database.

Larry Linson
Microsoft Office Access MVP

Larry Linson