Could have swore I tried that, it's the most obvious! But I put it in again and it worked! One other question. What would the path be on a remote server?
As far as I know you can't use Access on a remote server, you can do that with Sql Server and MySql and then you use the IP-number of the server to point to the server and the db-name to point to the database, but like I said: I don't think that works with Access.