One Access Database file, multiple applications?

[John]

Hi,

A client has a web application that talks to an access
database. They have recently employed some load balancing
techniques that now spreads the application across two
servers. Now whenever a connection to the access db is
attempted, we receive an ODBC error complaining that the
MDB file is opened exclusively by another user. Is there a
way to allow both appplications to access the db
concurrently?

Thanks,
John

 

[Rebecca Riordan]

You can set the default opening mode in the Options dialog under the
Advanced tab.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[logicmystic]

I am getting the same error with a similar problem. I have already set the default open mode as shared, even turned off all record locking. Still getting this problem when a user opens the database to edit records (not even the same table that is viewed on the web) and another user tries to pop up the web page that has an ODBC connection to the database. I get the MDB file is opened exclusively by another user.

Are there any other ideas

----- Rebecca Riordan wrote: ----

You can set the default opening mode in the Options dialog under th
Advanced tab

HT

--
Rebecca Riordan, MV

Designing Relational Database System
Microsoft SQL Server 2000 Programming Step by Ste
Microsoft ADO.NET Step by Ste

http://www.microsoft.com/mspres

Blessed are they who can laugh at themselves
for they shall never cease to be amused..