Problems Using Microsoft SQL Server Migration Assistant for Access
I’m having an issue with Microsoft SQL Server Migration Assistant for Access and I’m hoping someone can tell me what the problem is. I have an MS Access 2019 database that I’m trying to migrate to SQL Server using this tool and it seems to be having a problem reading the tables and such. It gets hung up while trying to read them and I can’t even get to the stage where it allows me to select the tables and queries. This is the first time this has happened. I’ve used this tool before with any problems. I even tried it using a different database and had the same issue. It is an Access 2019 database 64 bit and I am running Windows 10 64 bit. Any help you can provide is appreciated.