Close External DB with VBA (1 Viewer)

[mjcaestecker]

Greetings All,

A little background first:
I have a program built with VBA and Access that sends an xml command to a credit card terminal for processing. when the command is sent to the credit card terminal, another database opens which gives the user the option to close the connection between program and credit card terminal.

The issue:
What I really need to do is to be able to close the external database with the cancel commands in it when the main database and credit card terminal are done talking to each other (in the case of a successful transaction). Is this possible??

Thanks,

-Martin

 

[thechazm]

You could simply create a single table in the remote database that has one yes/no field (being boolean) and toggle it on or off to tell the remote database to do something eg (close or do something else). Just make sure the remote database has a timer that runs on a short time and inside the timer before disconnecting or closing just reverse the value so it's setup for the next time.

Hope that helps.