Your connection across the network to a MS Access db is still file access so you'll have to make sure that the db is shared out from the server so that the client can see it at which point, yes, you will need to add the ip into the connection string.
As a note, whenever you have connection string questions, the first resource that you should use is
www.connectionstrings.com