While peer to peer works fine, a client-server setup is generally better for a network. There shouldn't be a port issue. Simply install AC on the server where its databases hole the data, then when you run AC on the clients, they will look for a database. Choose the bottom option (No), and browse to the AmazingCharts.mdb database on your server.
What operating system are you using on your server? I would be interested to know why you are using static IP addresses on your clients (which you of course can) rather than utilizing the server's DHCP.