How do I refresh my connection before doing the file transfer?
I have an Access ADP application (back end sql server). I'm building an import screen to import files. The process is that the user selects an Access MDB file and supplies the table name to import. Once the "import" button is clicked I drop the existing table using a stored procedure via docmd.runsql(exec stp_APDB_Drop_table import_TDA;) , I then perform the transfer using DoCmd.TransferDatabase acImport, "Microsoft Access", Me!WageReportPath, acTable, Me.tableName, "import_TDA", no
The issue is that the table gets imported as import_TDA1 because it doesn't recognze that the table (import_TDA) was dropped before performing the transfer. How do I refresh my connection before doing the file transfer?