I have a 10+ year old VB & MS based Access CRM system. I would like to query the mdb file using a third party software package via ODBC. We already have this working and by retrieving all records from a table. If this were SQL Server we would use Stored Procedures and pass parameters to get a specific result set when we query. I need a few simple stored procs, or the equivalent for MS Access, added to an mdb file that achieves the same parameter driven results. I am looking for 5 different queries all which should just be based on a single field ID. Example: Get list of all phone numbers associated to a unique contactID
I would also want an example of an update table record and insert new record.
This is all to supplement this legacy CRM with a few web forms for a small number of uses.