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?

  1. 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.

0
edit delete
are you sure?
asked Barry Pettis

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions