I have something weird I'm trying to accomplish and was wondering if anyone has tried/accomplished this.
Here's the problem (briefly).
I have some power users of a system that I built that use MS Access as a frontend to SQL Server. They have direct table access. I want to wean them off of this, and would preferably like to give them some stored procs... unfortunately they have some mini apps in MS Access against the data. Beyond me teaching them how to call SQL server via the Jet engine (creating a connection to SQL through a connection/recordset object) is there any way I can hook a .Net assembly into Access that would let me display some dummy tables (or dummy queries) that when called will invoke methods in my .Net assembly (BTW, this is MS Access 2003).
I've been looking through the mess that is MS Access and can't seem to make heads or tails of how I can do this (or even if it is possible).
I'm going to Q&A this one...
| posted on Monday, July 26, 2004 4:15 PM