Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Data Source of Reprt (Access Data Table) @ runtime

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Please help,

I have an application that reports data from an external database (via ODBC) but its very slow. I have found that if I take a copy of the data, store it locally in an Access table then set the datasource of the report to this table, it is much faster. Can someone please either tell me...

1. How to speed up the ODBC connection or.
2. How can I change the report to look at a different table from my VB6 front end ?

I am sure this has been asked many times.

Cheers
 
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
246
SoftwareRT
SoftwareRT
bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
167
bbranco
bbranco
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
221
anandm19
anandm19
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
208
RoknRole
RoknRole
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
235
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top