ODBC Connection to XXXX Failed

Trying to open a Query or Table in Microsoft Access with linked tables to Sage 50 / Peachtree Accounting.

ODBCFailedDialog

This error can happen for two reasons:

  • The dataset was moved to a new location.
  • Another user is performing an exclusive task in Sage 50 / Peachtree.

 

Make sure all users have exited Sage 50 / Peachtree.

Look in your company folder for a file ~PVSW~.LOC and delete it.  This is a Pervasive Location file for the Pervasive Database Workstation Engine and does not contain any of your accounting data.

If you are unable to delete the ~PVSW~.LOC you may need to reboot your computer or the computer where the data is physically located (your fileserver).