I have an Access front end working with data in a SQL Server 2005 back end. Everything works well, but for some users who have slower connections, through a VPN, they get errors like Error#-2147467259 was generated by Microsoft OLEDB Persistence Provider Unspecified Error. I cannot find any specific information on this one, but it seems to me it has to do with the volume of data and the slowness of the connection, like the SQL being executed has timed out. I can run an mdb on this users machine and trap the offending SQL statement, put it into my SQL Server Management Studio and with my very fast connection, it runs with no error.
Does this make sense? Can anyone shed any light on the situation? Is there a SQL Server 2005 setting I can change to allow for a longer timeout, if that is what it is?