Tutorial Ref.com

AutoIt:Error Problem Connecting to Access 2007 Database. "The requested action with this object has failed"

If you have trouble connecting from autoit to connect to the Access 2007 database and you receive the following type of error then it may be related to changes you made recently to your Access tables.

1
2
3
4
5
6
7
8
9
>Running AU3Check (1.54.14.0)  from:C:\Program Files\AutoIt3
+>16:10:14 AU3Check ended.rc:0
>Running:(3.3.0.0):C:\Program Files\AutoIt3\autoit3.exe "C:\Program Files\AutoIt3\SciTE\bestIraRescue_Articlecity3.au3"
C:\Program Files\AutoIt3\SciTE\bestIraRescue_Articlecity3.au3 (40) : ==> The requested action with this object has failed.:
$adoCon.Open ("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & $_dbname)
$adoCon.Open ("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & $_dbname)^ ERROR
->16:10:15 AutoIT3.exe ended.rc:1
+>16:10:16 AutoIt3Wrapper Finished
>Exit code: 1    Time: 1.886

In other words, if you made a change in a field of a table then you will receive the above error from Autoit. So to correct this and to re-establish a connection to your Access database then all you need to do is close the table and reopen it. You only need to do this for the table and forms in which you made changes to.

TutorialRef.com - tutorials, guides, how-tos, helps