I am attempting to update an Oracle database table via VBScript. It appears that the macro which performs this action executes on the client machine, even though they are viewing the document on the access point. Since the users do not have the providers set up on their PCs, they encounter the "Provider not found or not correctly installed" error.
Has anyone else done this? Is there a method to keep the connection and queries server-side?
I thought the access point was supposed to be "zero-footprint".
