Through the advice from this plat form I have moved all the ms access tables to Ms Sql server express with some amendments of course on the sub forms and data type which were a problem, I avoided the pass through queries due to some challenges on updating. So I'm using the less DSN File and ODBC 17 which is working fine and the speed is no different with Ms Access Back-end:
(1) I want to deploy this application to a client outside our network, this mean there will be a new server to host the tables, now correct me if I,m wrong here:
(a) I will download an MS Sql Server Express on a nominated computer to act as a server where all other 50 work stations will be linked
(b) On the 50 work station I will install the same ODBC 17 and MS Access runtime 2016 if no full license available
(c) The ODBC connection string will now change or I will replace my computer name currently showing to the new computer or server name. After that before logging out I will compile the application to accde, I know after make an accde it may want to log in, but at this point I expect to fail because of the change to host computer, but when I install it to one of the work station mentioned above I expect it to located the correct server at that point.
(d) Anything else?
MS Access 64 Vs 32
Here I have serious problems most of my clients are now shifting 64 BIT office , now I understand there is a code out there that can allow a 32 BIT written application to run on a 64 BIT Ms Access , kindly help me here.