This is a Microsoft Great Plains 7.5 error message that I need to correct. Our company Controller is receiving the following error: Great Plains error - unable to save to batch activity table.You will not be able to use this batch.. How can I correct this error? I a m running Great Plains 7.5 on a Microsoft 2003 enterpriise server with SQL 2000 Server on the same box.
I think I have your solution. This article gives you what you need to correct your batch locking issue:
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…