Tekhelpnet
Technical User
Hi again!
I have 2 views in Oracle that I am connected to through ODBC. Connection is bad like really bad so I had to create 2 static tables otherwise my report would not open in desing view. It crashes Access while opening in design view! Little over 1400 records per view. Nothing really but this is how it is.
Views itself opens in a second! Report based on this view opens forever. No calculations, no sub reports (yet) no nothing. Why is these views are affecting oppining of Reports so much? Any ideas? And if so how to fix it?
When my Reports are built they all will be going off those 2 views or static tables.
What your suggestion on having code to run Make table query or Append query is better way?
I have 2 views in Oracle that I am connected to through ODBC. Connection is bad like really bad so I had to create 2 static tables otherwise my report would not open in desing view. It crashes Access while opening in design view! Little over 1400 records per view. Nothing really but this is how it is.
Views itself opens in a second! Report based on this view opens forever. No calculations, no sub reports (yet) no nothing. Why is these views are affecting oppining of Reports so much? Any ideas? And if so how to fix it?
When my Reports are built they all will be going off those 2 views or static tables.
What your suggestion on having code to run Make table query or Append query is better way?
