Can I update the backend table from the frontend with a command button on a form? I have a linked table to the backend. I want to rename the current linked table and replace with an imported table. This is my current code to do this in the front end:
Code:
DoCmd.Rename "tblMstr" & Format(Date, "yyyymmdd"), acTable, " tblMstr "
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, _
" tblMstr ", "C:\Users\folder\Desktop\wfolder\ Mstr.xls", True
Because it’s a linked table; I would like to code it in the frontend to modify the backend if possible.