Assist with AHK to send / receive queries to MSAccess
Has or does anybody have information about working in "AHK" "Auto Hotkey" and connecting to an access database?
- Have found this link: https://github.com/IsNull/ahkDBA
2. Get an error "Falied to create connection" on the command comobjectcreate("ADODB.connection") within the AHK file.
I've tried to use the following connection strings:
Provider=Microsoft.Jet.OLEDB.12.0;Data Source=C:\Users\BPettis\Desktop\AHK-MsAccess\IsNull-ahkDBA-fcf5fbc\IsNull-ahkDBA-fcf5fbc\Test\TestDB.mdb;User Id=;Password=;
and
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\BPettis\Desktop\AHK-MsAccess\IsNull-ahkDBA-fcf5fbc\IsNull-ahkDBA-fcf5fbc\Test\TestDB.mdb;User Id=;Password=;
neither connects.
I do use ADO to create connections from within Excel. The AHK warning displayed states that maybe the provider has not been correctly installed.
So if someone has or is successfully using AHK to query into/out of an MSAccess database ... I'd greatly appreciate some help creating a connection.