turnerr
asked on
Error 3262 Couldn't lock table
My App uses a Jet32 access database (table type).
One process has the database opened for "read-only"
CODE:
Set dbsNew = wrkDefault.OpenDatabase(my DBfile, False, True)
' open record set
Set bbrst = dbsNew.OpenRecordset("bb_c ells", dbOpenTable, dbReadOnly)
Another process on the same PC tries to open the database
to write to a Field in the same table.
CODE
Set dbsNew = wrkDefault.OpenDatabase(Pr ojDBPath, False)
' open record set
' optimistic only locks dbase at point of .Update
Set bbRst = dbsNew.OpenRecordset("bb_c ells", dbOpenTable, dbOptimistic)
Why does the above error occour.??
One process has the database opened for "read-only"
CODE:
Set dbsNew = wrkDefault.OpenDatabase(my
' open record set
Set bbrst = dbsNew.OpenRecordset("bb_c
Another process on the same PC tries to open the database
to write to a Field in the same table.
CODE
Set dbsNew = wrkDefault.OpenDatabase(Pr
' open record set
' optimistic only locks dbase at point of .Update
Set bbRst = dbsNew.OpenRecordset("bb_c
Why does the above error occour.??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.