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 exported table from ms access to sql server to create the table copy in sql server.
2. Then added Primary Key in sql server table.
3. I have right clicked table in MS Access and selected Linked Table Manager to select the table in sql server.
4. I have modified the Form with the new table. I am able to save records with the form in the new table and it is working perfectly fine.
The issue is when I copy the ms access .accdb project file to a different computer, then there is an error in:
1. Opening the form: ODBC--connection to <datasource_name> failed.
2. Relinking the table: ODBC--call failed. Data source name not found and no default driver specified (#0)
The sql server driver is already installed.
Please suggest any workaround to fix this issue.
- 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?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.
