Re: Tool to compare two databases (one Access, one SQL Server)

Hi Edward,

I am just wondering -- is your system using ODBC to link the tables from
the sql server to the Access FE? Are there any relationships on your
tables?

The linked server will only work if you have to original mdb located on
the same computer as your sql server. I can show you procedures you can
use for making these comparisons easily. Just need to know the things
above.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
.