[AccessD] Closest thing to using SQL TVPs in Access?

[Paul Wolstenholme]

I'm only using table valued parameters in SQL Server (MS Access is just the
user front end).
In SQL Server I have several triggers that pass a column (the simplest form
of table) of key values to a stored procedure.  The stored procedure
executes one or more queries filtered using the key values.

That was all just a trick to save some aggregated data in a table and keep
it up to date, using a minimal amount of recalculation, when triggered by
changes to elements of the source data.  I did that either because repeated
requerying was slow and/or because the results were hard to merge into an
updateable query.

Paul Wolstenholme


On Fri, 2 Aug 2024 at 07:11, Ryan Wehler <wrwehler at gmail.com> wrote:

> Has anyone got any neat tricks to some table-value parameter like sending
> of data to stored procedures from Access?
>
> You can send DataTables and the like as a TVP in .NET/C# etc.... pretty
> nifty. Thought I'd pick some brains on it.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>