Search results

Hello, I have a problem with the "DoCmd.DeleteObject acTable" command. My Scenario: I have a database which is connected via ODBC to a online database. My local database needs to be updated from time to time and this updating involves a few steps which I put together in code and execute via...

Hi MajP, this works almost perfect thank you so much. Unfortunately I get a Runtime Error for the line "db2.DoCmd.OpenForm "Form1" Where exectly should I implement my code in yours? Sorry if these questions are obvious I'm very rusty in vba

Thanks for your reply I was hoping for someting easier. I thought the value of "Set db" could be changed. I need the linked tables to be local so I dont lose the data when the Sources of the linked tables go down. Due to business we might not be able to connect to these sources for a while so I...

Hello, I am tasked with providing code for backup of linked tables. These tables are supposed to be saved in a new database but as a local file. I have the code for transferring the linked tables into a new database. Sub BackUp() Dim dTime As Date On Error Resume Next dTime...