Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2005 to Access 2000/2003

Status
Not open for further replies.

dashen

Programmer
Joined
Jul 14, 2005
Messages
233
Location
US
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?
 
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top