multiple users, different servers, access "file already in use"..

[asdf]

Hello

I'm just wondering why this happens.

I have a web page that gets data from an access database. It works fine if
the DB is on the same server as web page. I can look at the web page and have
the DB and all the tables open at the same time with no errors.
If the DB is on a different server, the web page works fine until I open the
DB. If I open the DB, the web page shows an error and says that the file is
already in use.
I was reading something about splitting the DB and making an FE and BE so I
tried it. I can open the DB and look at the the web page fine, but the web
page stops working as soon as I open a table.
Why is that?
How can fix it? Or should I just keep the DB and webpage on the same server?

Thanks!