470,647 Members | 1,056 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

SQL Server -> MS- Access VBA

Hi all,

it's possible from a SQL Server (stored procedure) call (execute)
a VBA procedure in a MS- Access database?

Thanks,
Roberto
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Jul 23 '05 #1
2 1493
Possibly, if there's some general way to execute VBA from outside
Access. From an MSSQL stored proc, you could use xp_xmdshell to execute
a batch file, or the sp_OA% procs to manipulate COM objects. But both
of these options are restricted to sysadmin users by default, since
they may open up big security holes.

You might want to post in an Access group, to see if there's a
'standard' way to execute VBA from outside Access, then consider how
you could (or should) use that mechanism from MSSQL.

Simon

Jul 23 '05 #2
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com
Possibly, if there's some general way to execute VBA from outside
Access. From an MSSQL stored proc, you could use xp_xmdshell to execute
a batch file, or the sp_OA% procs to manipulate COM objects. But both
of these options are restricted to sysadmin users by default, since
they may open up big security holes.

You might want to post in an Access group, to see if there's a
'standard' way to execute VBA from outside Access, then consider how
you could (or should) use that mechanism from MSSQL.

Simon


ok,
thanks,
Roberto
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Developer | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.