Forum Discussion

ebodien's avatar
ebodien
Contributor
8 years ago
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.

  • ebodien's avatar
    ebodien
    8 years ago

    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.

1 Reply

  • ebodien's avatar
    ebodien
    Contributor
    8 years ago

    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.