Hello,
I connected my Access database with SQL Server via ODBC. Once changes are made, I desire that the data (tables) is automatically updated in Access. I tested by pressing the F5 button, it worked sometimes, but I think it is not an effective solution especially when i convert my database to the runtime mode (*.accdr). Has anyone tried to resolve this probleme and refresh automatically in a database Access?
I connected my Access database with SQL Server via ODBC. Once changes are made, I desire that the data (tables) is automatically updated in Access. I tested by pressing the F5 button, it worked sometimes, but I think it is not an effective solution especially when i convert my database to the runtime mode (*.accdr). Has anyone tried to resolve this probleme and refresh automatically in a database Access?
