database opens in exclusive mode over LAN

[bloody_football]

I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'.
Is there a way of opening the database over the LAN and allowing the Internet to see it?

 

[RuralGuy]

When you go to Tools>Options>Advanced tab how do you have your Default open mode and your Default record locking set?

 

[bloody_football]

Default open mode = shared
Default record locking = No Locks

 

[Robert88]

Your settings seem good but have they been changed to this or were they like this when you first create the database?

If they have been changed make a new database with these settings and re-import the content of your current into the new.

Good Luck.
Rob

 

[RuralGuy]

Sorry Mate, that's the extent of my guessing about the problem.

 

[bloody_football]

thanks anyway

I've decided to use a 'replication' of the database, still reading up on it to make sure I do it properly

James

 

[adi32]

i have a similar problem
my db worked fine in lan but when i used compact and repair it says that the db is in exclusive mode by another user

 

[bloody_football]

I have a .TXT file with all my databases, it's the first thing you see when you go into that section, the title of the file is

"0 - Don't forget, if you compact the database then the permissins get changed"
and the file is empty

Hope that helps.

James

 

[adi32]

and ? what do you suggest?

 

[boblarson]

Separate front-ends for each user, backend can be accessed by each front end. There's lots of posts around that, including reasons why you should never be accessing the same mdb file by multiple users on a LAN/WAN. While it's true that you can do it (connect to the same mdb by multiple users) that doesn't mean that you SHOULD do it.

 

[The_Doc_Man]

The problem is almost certainly permissions.

Remember that through a LAN you are using the directory SHARE to open the MDB with Access and in this case, the LAN connects you via FILE SERVER operations.

When you connect via a web front-end, you are using IE permissions, which are different than LAN/SHARE permissions.

You need your network admin to compare "effective" permissions. In the case where Open Exclusive occurs, the odds are that you don't have proper access to the LDB file or the ability to CREATE the LDB file via LAN. Either would have the effect of forcing an Open Exclusive because Access cannot arbitrate its own fine structure without the LDB file being fully available.

Just FYI (and for your network admin), you need the equivalent of the 'coarse' permission "MODIFY" on the folder and all the files therein. Or if you need to use the advanced permissions, everything EXCEPT Take Ownership, Set Permissions, and Set Attributes. Even then, I'm not sure about the last one. In general, the only ones you DON'T need are the fine-grained permissions that are different between MODIFY and FULL on the coarse-grained settings on the permssions tab. That goes for the folder as well as the files in it.

You specifically must be able to open (for write), create, and delete the LDB file in that folder. Plus all sorts of similar "wide-open" permissions on the LDB and associated files.