[AccessD] New to ADPs

I am about to play around with my first ADP.  I know nothing, have never done one.

I have a smallish but well developed Access FE already working with existing data in SQL Server.  I 
use ADODB linked tables with the SQL Server IP:Port, Username and password hard coded (saved) in the 
tables, and DAO code for many purposes.

So what do I need to know to convert my MDB based linked FE to an ADP solution?  Also what do I do 
when I move my data from one SQL Server instance to another (I will be doing that soon).  The IP 
part of the server info will change when I do that.

Any words of wisdom before I begin?

-- 
John W. Colby
www.ColbyConsulting.com