Forum Discussion
Unable to save record in ms access project after copying to different computer
Hi, I have created an MS Access project in 2007-2016 format. The OS is Windows 11. I have created datasource under Machine Data Source by selecting ODBC driver 17 for sql server. 1. First I export...
There are a couple of possibilities, so please clarify.
You installed the same ODBC 17 driver on both computers, correct?
You used the Machine Data Source option to create a DSN on the first computer. Did you create the same DSN on the second machine?
You installed the same ODBC 17 driver on both computers, correct?
You used the Machine Data Source option to create a DSN on the first computer. Did you create the same DSN on the second machine?
I have updated the question with specific error details.
Correct, the drivers are installed on both machines.
No, I have not created new DSN in Machine Data Source in second computer. I have assumed it should work directly. Please correct me if I am wrong.
I also notice that the DSN is not present in Machine Data Source. Probably, hence the error.
If I create a new DSN, Relink and then modify the Forms, it seems to work fine. But I would like to save this rework each time I share the .accdb file to another user.