Nerissa,
Which table is causing this problem?
Typically, you'll get the "File access is denied" message if you're trying to open a table that has already been locked (FLOCK(), USE mytable EXCLUSIVE, or BEGIN TRANSACTION will give you the same message) by another user.
The "Attempting to lock" message comes after the table has already been opened successfully by multiple users. Then, one user successfully locks the table. When the second user attempts the lock while the first lock is still active, pop goes the message. Check help on UNLOCK. Maybe using this when you see the problem will help you figure out what's happening.
Hope that helps more,
---J
>Hello Jason,
>
>I am wondering why I cannot bring up my MM application when other user has already locked the table that I used in my project. The error says file access is denied to the table. That's why we are having an impression that MM is not opening the table as read only.
>
>So I tried to do it in VFP command window. I set exclusive off and then flock() the table. Then I opened another VFP, set exclusive off and USE the view for the table. The message "Attempting to lock...." was displayed at the bottom. I waited for a few minutes and it's still not done. So I just closed VFP.
>
>I will really appreciate any help.
>
>Thanks a lot.
>
>Nerissa