Sql Server SP to Access

Question

Sql Server SP to Access

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

pg53 Ten Centuries Points: 1303 More actions · Answer 1

I think he means 're-create in Access, the sp I currently have in SQL Server'

Anyway, if so, we need to know what's in the original sp. If it's a simple query, it may be OK (unlikely) - most likely, as James said, he'll have to use queries and VBA.

Dick Schroth Right there with Babe Points: 725 More actions · Answer 2

It might be a good idea to post the SP you are trying to recreate, so someone could suggest a workaround. But there is no such thing as a true stored procedure in Access. Usually you would need to use a parameterized query or you could build a SQL statement on the fly.

Dick Schroth

dschroth@schrothsystems.com

http://www.schrothsystems.com

noeld SSC Guru Points: 96590 More actions · Answer 3

Ahh the joy of guessing ... we will never know what he actually wanted? ... unless the poster replies back

* Noel

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Ninja's_RGR'us

SSC Guru

Points: 294069

July 12, 2005 at 10:14 am

#573508

Still valid point .

Guess we'll never know.

Geoffrey Wrigg SSC Eights! Points: 945 More actions · Answer 5

Probably the Access feature that's most analogous to a stored procedure is the Module object. If I were in your shoes, I'd do some research into Access modules and see whether they would do what I needed.