[AccessD] MSAccess XP to SQL2005 Backend

I have been using an MSAccess adp project FE that connects to a SQL2000
BE database for about 3 years now.  The administrative powers that be
will be upgrading the SQL 2000 server to SQL 2005 next month.  I did a
test upgrade and got the following error message:

You have connected to a version of SQL Server later than SQL Server
2000.  The version of Access that you are using was released before the
version of SQL Server to which you are connected.  For this reason, you
might encounter problems. 

The problem I am having is that all tables and queries are not
visible/accessible/usable.  

Does anyone know of a service pack or patch that would give me an easy
solution?

Thanks

-Z

Stephen R. Zayko P.E.
SECOR International Inc
2321 Club Meridian Drive, Ste E.
Okemos, MI 48864
 
(517) 349-9499 (ph) ext 224
(517) 204-5136 (cell)