-246255:Could not use ""; file already in use.

[Vinod Koti]

Hi All,

I am using the MS Access 2000 DB. VB6 application tries to access the database and i am getting below error,

" -246255:Could not use ""; file already in


use.:\\HYTEDC\MN42Data$\database\SecureOperator.md b" .

The "SecureOperator.mdb" is password protected.

All the users are having full permission (read, write & create rights) to the folder where database is located (in server). Still i am getting same error.

Please suggest me the resolution for this.

Thanks in advance

Regards,
Vinod koti

[John_G]

Does every user get this message, and under what circumstances? Can more than one user access the database at the same time?

If only one user can be in the database at a time, check your VB code that opens the database - is it trying to open it for exclusive access? (I don't use VB6, so I can't help with the syntax for that).

John

[Vinod Koti]

Does every user get this message, and under what circumstances? Can more than one user access the database at the same time?

If only one user can be in the database at a time, check your VB code that opens the database - is it trying to open it for exclusive access? (I don't use VB6, so I can't help with the syntax for that).

John

John,

All the users getting this error when trying to access the mdb file with optimisticLock.