Could you point me in the right direction to look for information about... how to connect successfully to MSAccess & SQL Server 2000

Use DBD::ODBC. It works beautifully for both Access and SQL Server. I am using it right now for a program. Not a problem at all.