Have you migrated access tables to sql server while leaving the front end on access? I think I have done it once some time ago but am having trouble. I get a connection error message in SSMA that it can't connect to sql server. I may have a firewall issue. Any idea on how to resolve this? Thanks.