I've got an Access application which does a number of things, one of which is uploading some data from Excel to SQL Server. This was taking forever until ACPerkins helped me resolve an earlier question
However, when the user who normally runs this upload attempts to do so from his computer he gets a runtime error: #3146 - ODBC--call failed. When I moved the app from the SQL Server machine to my local machine, I have the same problem.
Any way to resolve this error? The file being uploaded is on a shared network drive with the same path string regardless of whether it is running from the server of either of our local machines. Would it make a difference if we used a UNC naming convention for the path?