Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

eseguire Stored procedure parameters da VBA

355 views
Skip to first unread message

pfm

unread,
Mar 13, 2018, 6:33:50 AM3/13/18
to
salve

ho un'applicazione Access collegata a SQL server via ODBC.
ho creato una StoredProcedure in SQL con alcuni parametri

potete aiutarmi a richiamare la stored procedure da Access passandogli i parametri definiti dall'utente?

GRAZIE

@Alex

unread,
Mar 13, 2018, 7:12:47 AM3/13/18
to
Io usavo DAO, con una Query PassTrought invocando EXEC sp_name...

Vedi questi LINK:

https://social.msdn.microsoft.com/Forums/office/en-US/b4521015-4ca1-4644-adea-bdbd0b8106c7/best-way-to-execute-sql-stored-procedure-with-parameters-from-access-2010?forum=accessdev

https://access-programmers.co.uk/forums/showthread.php?t=129352

https://stackoverflow.com/questions/24248870/calling-stored-procedure-while-passing-parameters-from-access-module-in-vba

https://stackoverflow.com/questions/40828608/execute-mysql-stored-procedure-with-parameters-in-access-frontend-via-vba?rq=1

@Alex

pfm

unread,
Mar 13, 2018, 10:53:19 AM3/13/18
to
grazie

veramente gentile!

posso cosi' crearmi una maschera in access in modo che l'utente possa definire i parametri della stored procedure
0 new messages