I am using Access 2000 as a front end reporting tool against a SQL Server 7.0 database. When running one particular report, the SQL Server Login form appears (and must be dealt with) 50 or more times.
The database is automated to output many reports, both to PDF files and paper, automatically. Each report is generated multiple times for different client/region/line of business combinations. I just finished developing this report and want to put it into the automated production, but obviously can't until I can get it running without constant intervention.
I'm going to include way to much detail, but whoever can help will probably need it:
There are seven linked tables which link to views in SQL server:
· dbo_vwHeaderLOB
· dbo_vwS071 thru dbo_vwS076
There are seven queries:
· qryHeaderLOB references dbo_vwHeaderLOB and filters forthe current client/lob
· qryS07-1 (dbo_vwS071 inner joined to qryHeaderLOB)
· qryS07-2 thru 6 are the same but reference the appropriate views
The report consists of five subreports and one Microsoft 2000 Graph Chart
· sbrS07-1 references qryS07-1
· sbrS07-2 – references qryS07-2
· sbrS07-4 thru 6 reference qryS07-4 thru 6
· The chart references qryS07-3
The main report references qryS07-1 and each of the subreports/chart links on the provid field (both master and child)
If I open the views, queries or subreports, I have no problem. If I open the main report, I am prompted (many times) for the SQL Server Login.
Any ideas on why this occurring and how I can prevent it?
Michael
The database is automated to output many reports, both to PDF files and paper, automatically. Each report is generated multiple times for different client/region/line of business combinations. I just finished developing this report and want to put it into the automated production, but obviously can't until I can get it running without constant intervention.
I'm going to include way to much detail, but whoever can help will probably need it:
There are seven linked tables which link to views in SQL server:
· dbo_vwHeaderLOB
· dbo_vwS071 thru dbo_vwS076
There are seven queries:
· qryHeaderLOB references dbo_vwHeaderLOB and filters forthe current client/lob
· qryS07-1 (dbo_vwS071 inner joined to qryHeaderLOB)
· qryS07-2 thru 6 are the same but reference the appropriate views
The report consists of five subreports and one Microsoft 2000 Graph Chart
· sbrS07-1 references qryS07-1
· sbrS07-2 – references qryS07-2
· sbrS07-4 thru 6 reference qryS07-4 thru 6
· The chart references qryS07-3
The main report references qryS07-1 and each of the subreports/chart links on the provid field (both master and child)
If I open the views, queries or subreports, I have no problem. If I open the main report, I am prompted (many times) for the SQL Server Login.
Any ideas on why this occurring and how I can prevent it?
Michael
