![]() Answer / Solution: When Kofax Capture / Ascent Capture connects to a table for Database Validation, it retrieves the entire table contents.If it's any use, the connection string is: Dsn=Spiceworks database=\\MyServer\db\spiceworks_prod.db stepapi=0 notxn=0 shortnames=0 longnames=0 nocreat=0 nowchar=0 fksupport=0 oemcp=0 I did read in another post a reported issue with slow response time displaying all the Spiceworks tables, but I do not believe this to be the case here as the 'expanding' message does not appear.We often use a two file approach when developing with live connections. What you would want to do is add the excel data into the original data source that is supporting the live connection. There is not a method at this time to conduct a data mash up data between Live Connection and other sources.The workbooks are all saved locally on my PC, so it’s not a network issue. ![]() ![]() Visually, what I see on the bottom right corner is that it is “Connecting to Datasource…” for the entire time, once that shifts everything else completes rapidly. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |