Microsoft Access Security Query

[martina]

This query is in relation to an Access 97 database.

A problem that we are consistently having is that whenever people are using the database under different user names, it only allows one user at a time to use it. So basically if three of us are on it updating files or enquiring on client details, two of us are locked out leaving only one in. Any help in this matter is greatly appreciated.

[Splash]

I may be being a floon here (I hateses Access with a passions, I does) but I believe this is a feature of Access - the .ldb file generated when someone is using a .mdb is the lock file and there isn't really any way around it.

That said, feel free to smack me round the head lots if I'm wrong.

Also this is the wrong place to be posting this kind of request - the Hexus.help forums is probably a better place for it.

EDIT - there y'go - a kindly mod spotted you!