Search results

Thanks all of you! As the table is not that big, time to delete/copy is acceptable and I implemented the simple solution Eberhard proposed. Great help!!!

sounds good but can you give a sample code for this?

OK, everything works fine now. But the delete/copy takes some time to execute. How to "lock" the application until copy is finished? Or give a message at completion?

Hello Eberhard, This module does the job but is there a way to execute the module at open? If not, how to connect a module to a button? Willy

All folks, thank you for your suggestions. First of all, I will try to explain what I have done already and what problems I encountered. 1) I have a (Joomla!) website and a web application that maintains a membership table in the Joomal! database 2) I have an Access DB that links, via an ODBC...

I want to have a FRESH LOCAL copy of the external DB table(s), every time I open te Access DB. When I choose for a "connected" table, it is not a "local" copy and performance is terrible. But when I choose to import the table, it is a "local" copy but then I have to do this manually every time...

I've over 40years IT experience but very little Access experience. Just simple queries, forms, reports, ... and always on a local DB. Now, I have to use Access to make queries, reports, forms on an external (MariaDB) database and therefore, I'm looking for some help.