I am working on a project that requires me to pull data from an Oracle database 11i into an access 2007 database. I've been able to configure the ODBC so that I can pull data into Access from tables and views, but I am not able to execute a stored procedure
from Access and return data. Is there some trick to this? I've seen some examples of using VB code to do this, but I need this to work for people that are used to doing it through the menu. Got any ideas? Thanks.