Can Open Read-only Database Manually, but not via VBA
Posted on 2004-09-16
Trying to access a read-only A2K database via a NT network using VBA. No protection/privilege problems when I manually open the DB, but I am unable to get beyond an "Could not Lock File" error using VBA.
The DB is read-only and does not have a password.
I am invoking the following code:
Dim dbReadOnly As DAO.Database
Set dbReadOnly = OpenDatabase(strPATH, vbFalse, vbTrue)
Thanks in advance.