Re: Stored Procedure from Access

it doesn't return records, just transfers data.

can you give me some syntax? it's a hard topic to search the web for.

"Dirk Goldgar" <dg@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ugJSbcoYGHA.1764@xxxxxxxxxxxxxxxxxxxxxxx
"scott" <sbailey@xxxxxxxxxxxxxxx> wrote in message
news:eGCmnXoYGHA.4144@xxxxxxxxxxxxxxxxxxxx
Is there any way to execute a SPROC residing on the server from an
access db on my workstation? Also, the access front-end isn't an
access project, just a regular database file.

I plan to link to the sql data tables from access, but didn't want to
create a project.

Yes. You can do it with a pass-through query, or using an ADO Command
object. As pass-through query is easiest, if you don't need to supply
parameters. Does the procedure in question return records?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)




.