Access ADE And Stored Procedures

[dazzer123]

I have recently created an access adp fount end for an SQL Server DB, when I put the ade onto the client machines everything is working ok except on 2 machines, on these machines instead of the stored procedures being listed as they should be they have been renamed 'storedprocedure;1'.

Where has the ;1 come from and why is it doing this, I have never encountered this problem before and any advice would be appriciated.

I have tried reinstalling Access but this didn't help I have also tried refreashing the connection to the SQL Server but again no joy.

 

[markVII]

Check your ODBC drivers used by the connection.
The symptoms point to translation error.

 

[dazzer123]

Thanks for your help, I done an Office and Windows update and this solved the problem.

Presumably it updated the ODBC drivers as you mentioned

Thanks for your help