I have a urgent problem with transfering Data from a DB2-Server to Access97.
Problem: for about 50.000 Datasets Access97 needs about 1min. To long for the users.
The responce time of the Pass-Through is 5 to 10 sec. Transfering Data about 50 sec.
Question: Is there somebody who can tell me how I can increase the datatransfer performance.
If QryExistJN("Tmp") Then DoCmd.DeleteObject acQuery, "Tmp"
WCF: Using basicHTTP user/pass authentication?
Submit form with variable for action?