Hi,
I am having issues with any sort of write functions to a MS access db from indusoft
The code is simple SQL to insert, this works one day and then not the next (although nothing has changed ie db connection, file permissions etc). It is like some service is shutting off that is required to write? (I can read no problem). Either that or the file is locking itself.
Could anyone please advise what checks I should do or any tests I could do.
I tried the secure viewer on the server as well, this has the same issue.
The current error I am receiving back in the tab is "operation must use an updateable query"
I am having issues with any sort of write functions to a MS access db from indusoft
The code is simple SQL to insert, this works one day and then not the next (although nothing has changed ie db connection, file permissions etc). It is like some service is shutting off that is required to write? (I can read no problem). Either that or the file is locking itself.
Could anyone please advise what checks I should do or any tests I could do.
I tried the secure viewer on the server as well, this has the same issue.
The current error I am receiving back in the tab is "operation must use an updateable query"