Hello
i am using Excel for VBA in a userform and using excel as userinterface 8userform)
I have an acces database, frontend-DB and backend-DB, where data is stored.
I have made a dataconnection in excel wich gets all data from the backend-database to a sheet.
It is updated whenever i open the worksheet.
When i work with the data i my userform (VBA) i work with the data in the sheet.and i save data to the database (using the command: refresh.all)
Problem is that i cant save data to the database when i have the dataconnection in the workbook.
When i delete the data-connection in the workbook there is no problem saving to the database.
Does anyone know what i am missing?
i am using Excel for VBA in a userform and using excel as userinterface 8userform)
I have an acces database, frontend-DB and backend-DB, where data is stored.
I have made a dataconnection in excel wich gets all data from the backend-database to a sheet.
It is updated whenever i open the worksheet.
When i work with the data i my userform (VBA) i work with the data in the sheet.and i save data to the database (using the command: refresh.all)
Problem is that i cant save data to the database when i have the dataconnection in the workbook.
When i delete the data-connection in the workbook there is no problem saving to the database.
Does anyone know what i am missing?