We have been told by SAP consultants we should not use RFC calls to maintain data in Access databases. Because of this we have been writing ABAP programs and SAP queries the users can run then manually download and import the data into Access using files.
Do RFC calls have overhead that we should be doing all these work arounds? We would like to have the Access databases just use RFC to get the desired data when the user needs it.
Any thoughts and recommendations are very much appreciated.
Thanks 😊
Chuck