My program works ok in office but on site fails.
Problem traced back to the Data Environment Provider.
Upto now I have used
Microsoft Jet 4.0 OLE DB Provider with Connection "E:\Databases\JobInfo.mdb"
Using this all works OK but of course on site the database has a different path.
So I changed the provider to Microsoft OLE DB Provider for ODBC drives using DSN JobInfo.
Whereas using Jet 4.0 everything OK in office I now get a run time error 2147217904 - Microsost ODBC M/sAccess Driver "Too few parameters expected 1".
The only change I have made is to the connection and pressing the test connection button shows connection is OK.
The SQL command is
SELECT * FROM tblCostHeadings, tblTransactions, tblTransHeaders WHERE tblCostHeadings.CostHeadingID = tblTransactions.JobCostHeadingID AND tblTransactions.JobTransType = tblTransHeaders.JobTransType AND (tblTransactions.JobNumber = Param1)
Can any one help??
Problem traced back to the Data Environment Provider.
Upto now I have used
Microsoft Jet 4.0 OLE DB Provider with Connection "E:\Databases\JobInfo.mdb"
Using this all works OK but of course on site the database has a different path.
So I changed the provider to Microsoft OLE DB Provider for ODBC drives using DSN JobInfo.
Whereas using Jet 4.0 everything OK in office I now get a run time error 2147217904 - Microsost ODBC M/sAccess Driver "Too few parameters expected 1".
The only change I have made is to the connection and pressing the test connection button shows connection is OK.
The SQL command is
SELECT * FROM tblCostHeadings, tblTransactions, tblTransHeaders WHERE tblCostHeadings.CostHeadingID = tblTransactions.JobCostHeadingID AND tblTransactions.JobTransType = tblTransHeaders.JobTransType AND (tblTransactions.JobNumber = Param1)
Can any one help??