ebodien
6 years agoContributor
Solved
Access change?
Was there a change in Access 2016/Office 365?
This query works fine on the PC with Access 2010 installed.
#Create query Qry = ADO.CreateADOQuery() Qry.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + \ "Data Source="+mySource #Specify the SQL expression Qry.SQL = "Select * FROM [String_Table] WHERE [String_Table].[RID] = :Num" #Specify Parameter Value Qry.Parameters.ParamByName("Num").Value = rid #Execute the query try: Qry.Open() except RuntimeError: Log.Warning("Unable to find database " + str(mySource) + " aborting test run.") return "Abort"
On the PC with with Access 2016/Office 365 the same project returns the Runtime error.
I figured it out. My helpfu was weak. All was finding were articles on testing the DB applications. A second search brought up the article on the issue of having TC x64 and Office x32 and how to resolve it by installing the different Access engine. I the access install and now TC comes up in x86 mode and I can use the query again.