troubleshooting Question

SSMA Access BE Linked Table Migration Linking Issue

Avatar of Tusitala
Tusitala asked on
Microsoft Access
2 Comments1 Solution218 ViewsLast Modified:
Hey guys,

So, I have got myself into a mess with SSMA and need some help!

As a first time user of SSMA, I was toying with it earlier to test it out and decided to import three existing tables from an Access be db into a test SQL server db that I created for testing.  When asked if I want to link the migrated tables back to the Access be, I checked "Yes".  All worked fine, typical SQL warnings, no problem.

Then, after the migration of my three tables completed, I viewed them in SSMA and did not like the results in some of the data types that were converted.  So, like any novice would do, I decided to have another go and proceeded to delete the tables from SQL and the linked tables from Access.

Now, whenever I try to run the same migration steps for the same three tables, SSMA keeps showing the tables that I previously deleted as "Linked" per below image :

linked
I tried using the Right Click -> "Unlink Table" command in SSMA but it fails each time with errors shown per below image :

errors1
errors2
I have also tried changing the destination SQL db, moving the tables to a new Access db, and for the life of me, I cannot seem to figure this out!

Any ideas on how I can move past this problem?

~Tala~
ASKER CERTIFIED SOLUTION
Theo Fitchner

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros