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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access 2003 and sql 2005
Good day all, I have recently installed sql 2005. when running access 2003 I get the following error messages. Anybody got a clue how to solve these?? Thank for your troubles. "This version of MS Access doesn't support design changes with the version os SQL you are connected to." "New...- EMEP
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
-
SP and forms
I have a Stored Proc which works when run directly, but when trying to run through form I get error message. Does anybody have a suggestion?? Thanks a lot Eric With cmd .ActiveConnection = cnn .CommandText = "dbo.SP_TravelRate" .CommandType = adCmdStoredProc .Parameters.Append...- EMEP
- Thread
- Replies: 10
- Forum: Microsoft: Access Project (ADP)
-
Error on SP as recordsource
I have a report it's recordsource links to as SP. To pass 3 variables I use a form to select the criteria. When passing criteria manually to the SP it runs OK. However when it's supposed to open the report with the required records it stays blank and I get the following error message "Must pass...- EMEP
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
