It works in the PCC but that is using the DSN I created on the server not the data files directly.
"Runtime error '-2147217865(80040e37)'
Table does not exist"
is the error.
Here is the code
Private Sub Form_Load()
cn.ConnectionString = "Provider=PervasiveOLEDB;Data Source=\\server2\synshare\syn\willow"
cn.CursorLocation = adUseServer
cn.Open
rs.Open "ps_hdr", cn, adOpenDynamic, adLockBatchOptimistic, adCmdTableDirect
cn.Close
End Sub
If there was a way to use the DSN on the server to run this as PCC does instead of installing the DSN on each workstation that would be great too.