Access 2013 Forms (application) is not responding post migration

[Lukesh]

Hi ,

I have a DB in MS Access 2013 and a few forms on Inventory/Customer details in Access . I have converted Access DB to SQL Server2016 using SSMA tool . Post migration and linking the tables to SQL Server , when i launch Access Reporting app and click on any form to open its not responding and not throwing any error . Please help .

Regards,
Lukesh.

[ranman256]

do the tables open?
are the forms connected to the tables?
are the macros enabled? (file ,options, trust center, enable all macros)
can you create an instant form from a table and does it work?

[Lukesh]

Hi Ranman , Appreciate your response .

To brief , its an existing Access application running well on Access Forms/Report including data . So i have migrated to SQL using SSMA tool and that was successful . All the tables are linked to SQL Server and from backend between SQL & Access data is getting created /updated.

However, post migration to SQL when Report are launched and click on any Report/Form nothing is happening . But if i replace the backup copy file .accdb , before migration its working fine.

I will go through the above steps and update back soon.

Regards,
Lukesh.

[ssanfu]

When I linked the tables in the SQLSE BE (I'm using SQLS Express 2014) to the Access FE, the names of the tables in the FE had the prefix "dbo". For example, the name of a table in the SQLSE BE is named "dbo.Employees" (with a dot). After linking the FE to the BE, the linked table name became "dbo_Employees" (with a dash).
I renamed the linked tables by renaming the table to "Employees" (deleted the "dbo_"). All forms then opened/worked....

What are the LINKED table names in the FE???