During my last project I stumbled upon a problem with the data connection to the MS Access database.
The ‘connect’ activity results in a ‘test succeeded’ after configuring it with the connection wizard. But when I try to perform a query (“Execute Query” - activity) it results in “SQL Server Error : Invalid object name”.
I have already searched the forum and tried multiple possible solutions, such as: using [ ] brackets, specifying the tables, …
When I open MS Access on the same computer and run the query inside the program, it works without issues. Can someone explain the issue?
The computer I’m working on is quite restricted, with a lot of permissions, fire walls, … The problem might be situated there? If so, anyone an idea on how to solve it?
Any help would be greatly appreciated.