I am currently transfering two access DB, A and B, to SQL Server. Using Upsizing wizard, the job was completed. However, one of tables in Access DB A has Access link to one of tables in DB B. Can we keep the link in SQL Server? If the link is still existing in SQL DB, how can I check the link is existed?

Thanks,

If you upsized to an .adp, you are stuck with ONLY SQL Server tables and a lot of conversion work. Also, the .adp is no longer being developed and although it is supported in A2007, there is no corresponding A2007 version. You are better off using linked tables when you upsize. That way, you will have minimal application changes and you can still use linked Jet tables or tables linked to Excel, etc.