Sorry expert again
I have hit a block again , I wanted to copy the customers details from Azure customers table, I was deceived thinking that since the data is visible in Ms Access linked tables and I,m able to copy paste manually , then the insert query was going to work, guess what it failed, there were couples of errors like:
(1) Data missmatch
(2) At the end it brought the unwanted password dialog again
If it works how do you copy the actual data not importing tables , this one I know it by using odbc it works well. I imported the actual table from azure using odbc in order to avoid data miss match , so in this case the table is just exactly as it appears in azure , now how do I copy the actual data and insert it in Ms Access new similar table, I want to be doing this so that any new data is also updated in Ms Access FE automatically. I prefer VBA way to deter users from doing it manually
These local tables will be used as lookup to speed up data capturing, currently this method is excellent , the only challenge is in the absence of automatic data copying from azure users have to update their FE manually individually. Currently the speed very good.
I have hit a block again , I wanted to copy the customers details from Azure customers table, I was deceived thinking that since the data is visible in Ms Access linked tables and I,m able to copy paste manually , then the insert query was going to work, guess what it failed, there were couples of errors like:
(1) Data missmatch
(2) At the end it brought the unwanted password dialog again
If it works how do you copy the actual data not importing tables , this one I know it by using odbc it works well. I imported the actual table from azure using odbc in order to avoid data miss match , so in this case the table is just exactly as it appears in azure , now how do I copy the actual data and insert it in Ms Access new similar table, I want to be doing this so that any new data is also updated in Ms Access FE automatically. I prefer VBA way to deter users from doing it manually
These local tables will be used as lookup to speed up data capturing, currently this method is excellent , the only challenge is in the absence of automatic data copying from azure users have to update their FE manually individually. Currently the speed very good.