I'm not certain if this is the right area of the forum for this question or not. If not, I apologize. We have a simple Access database that was created for the purpose of tracking bank deposits we make every week and this database has to be accessed from
a number of location across our network. Lately, the database is crashing/entering an inconsistent state almost every day and has to be recovered by replacing the current .mdb file that's corrupt with an older backed up copy. After doing some reading on the
subject, it seemed like migrating this DB to SQL Server 2008 made sense.
I downloaded and installed the latest version of SSMA (4.2), downloaded and registered the License, etc... and have started a new migration project. The issue is that as soon as I add the database, either through the wizard or manually, I get an Output error
that reads as follows:
Error occurred while loading children.
Access Object Collector error: Database
Could not load file or assembly 'Microsoft.Office.Interop.Access.Dao, Version=220.127.116.11, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
Error occurred while loading content.
I'm hoping someone here can explain this error to me since I can't seem to find specific infor
View Complete Post