I am doing a price evaluation of contract modification proposals from vendors. All of the data - proposal data and existing contract data - is all ODBC. The results of my evaluation are in local tables in the front end db and I create links to all required ODBC tables in the front end.
However, I have identified conditions where I can gain significant performance improvements by converting the ODBC links to local tables (verified by doing so manually at breakpoints in the VBA code). Because of the data volumes, though, I want those local tables to be in a backend Access database and I need to do that via VBA. Once I have linked to the proposal submission table, I can run my threshold tests to determine if the conditions are met warranting the use of local tables. If they are met, I need the link in the front end to become a local table in the back end. Then, I also need to create local tables in the back end database to contain the full contract price tables for each of the vendors on the contract.
Initially I tried the following:
Code:
sPTFullLinkName = "lnk_" & parmSubmissionIDSchema & "_" & strTableName
DoCmd.SelectObject acTable, sPTFullLinkName, True
DoCmd.TransferDatabase acExport, "Microsoft Access", dbpath, acTable, sPTFullLinkName, sPTFullLinkName, False
But, that only created a link in the backend database (at dbpath).
So, I changed acExport to acImport (everything else unchanged), and I get Error code 3709 The search key was not found in any record.
Any suggestions? Please.