multiple users...different servers.....access already in use..

[fluff]

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 DB 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!

[PianoMan64]

It is because when you open the database, you're opening it Exclusively. That means that you are the only one that can have it open and no other person can see the contents or do anything with it while you have it open.

That is the reason that your pages fail when you have it open. If when you open your database, you select Open either read-Only, or Open Shared, then that would allow you to open it and look at the contents, and not interrupt the IIS server when it is trying to render pages of the content that is in the database that you have open.

Hope that helps,

Joe P.