SQL Server 2005 to Access 2000/2003

[dashen]

Is there no work around to getting the ADP to work with SQL Server 2005?

Could I hard code using an ADODB connection to Update and Insert?

Any ideas people?

 

[dashen]

Dim stStoredProcCall As String
stStoredProcCall = "sp_SaveDefJobInfo " & 1234567 & " " & 1 & " " & "'09/18/06'"
DoCmd.OpenStoredProcedure stStoredProcCall

I tried something like this, but it gave me an error.

How do I pass parameters with a stored procedure call in Access to SQL Server 2005?

 

[lameid]

Dashen,

Your problem is not an SQL 2005 issue, it is a syntax one...

Check back in thread958-1251122

You were there.

You more or less have to use a form with input paramaters and open it in datasheet view instead.