I have an Access form setup to accept user input as static information. I then have an I/O card installed (PCI-7224 from ADLINK) to aquire pass/fail results from a RunCheck/PLC system. I want to create records using the form data and aquired results. The I/O card has an interrupt function that accepts a callback function address as an argument - interrupt occures, it calls the said function. This same function works perfectly when called from a cmd button on the form. It seems to be unauthorized to write to any table - local or SQL Server, when called from the interrupt. I can query tables, call other functions, change properties on my form using the interrupt callback function but cannot write data. I have declared all functions as public.
Can any one give some advice, please?
Thanks in advance.
Brent
Can any one give some advice, please?
Thanks in advance.
Brent