You can call a procedure directly - but it requires writing code to create an ADO recordset where you define and build the query to be executed. Here are some examples:
As for using a TVP - it isn't possible using ADODB. You would have to use ADO.NET and I am not sure if you can use it in Access.