.ldb files

[James Strachan]

Before I begin, I realise that there is probably no way
round this problem from other posts I have read and
placed on various forums, but I think it is a problem
that Microsoft could and should rectify!

The problem we are having is that one of our users has
created a database which merges data from two folders.
Some users only have read only access to one of these
folders, meaning that if a .ldb file exists (Someone has
the database locked) they are unable to write to the .ldb
file, and are unable to open the database. If the same
users open the database when it is not in use however,
they are able to open it, recieving a 'This document is
read-only' message from Access (because Access tries to
create the .ldb file if it is not there, fails to create
it, so opens the file as read only).

I realise that a possible way around this is to give
everyone write access to the folder, and change the
access rights of all the individual files, but I am
reluctant to do this due to disasters in the past!

Surely if when Access fails to create a .ldb file it
opens the db as read only, it would not be difficult, or
a security issue for it to open the db as read only after
attempting to edit a .ldb file and failing.


Any thoughts?

Cheers, James

 

[Joan Wild]

I realise that a possible way around this is to give
everyone write access to the folder, and change the
access rights of all the individual files, but I am
reluctant to do this due to disasters in the past!

You don't mention the disasters, but have you considered hiding the folder
where the mdb is? Users can't easily get to it then.

Another possibility is, since they only need read access, copy the mdb to
their local machine and have them use it there - anything they do won't
affect the network copy.

You can't get around the ldb issue that I'm aware of.

 

[Lynn Trapp]

James,
Your initial thought is correct for now -- there is no way around the
situation. Unless the users have full rights to the folder that the database
is in you will continue to encounter this problem. The key is to make the
..mdb file read-only rather than making the folder read-only.

 

[Guest]

You say for now...? By that do you mean you think this is
an issue Microsoft are looking at? And if not, how do I
go about suggesting it?

Cheers,
James

 

[Joan Wild]

You say for now...? By that do you mean you think this is
an issue Microsoft are looking at? And if not, how do I
go about suggesting it?

Since you are using the web interface to newsgroups, you can start a new
post. You can mark it as a 'suggestion', rather than a question.

 

[Lynn Trapp]

I don't know of any plans to change that. Nor did I have anything in mind
when I said "for now". You can go to Microsoft.com and do a search for
"Suggestions". You should get a page where you can make a suggestion for
making an improvement to a product.

 

[Lynn Trapp]

Since you are using the web interface to newsgroups, you can start a new

post. You can mark it as a 'suggestion', rather than a question.

Well, bust my buttons. I've never use the web interface and didn't know that
was possible.

 

[Joan Wild]

Well, bust my buttons. I've never use the web interface and didn't
know that was possible.

I believe it is now the preferred method to make suggestions/wishes known.
In addition, those that use the web interface, are able to 'vote' on
suggestions made.

 

[Lynn Trapp]

I believe it is now the preferred method to make suggestions/wishes known.

In addition, those that use the web interface, are able to 'vote' on
suggestions made.

Thanks again.