Link to home
Start Free TrialLog in
Avatar of turnerr
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(myDBfile, False, True)
 ' open record set
 Set bbrst = dbsNew.OpenRecordset("bb_cells", 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(ProjDBPath, False)
' open record set
' optimistic only locks dbase at point of .Update
 Set bbRst = dbsNew.OpenRecordset("bb_cells", dbOpenTable, dbOptimistic)

Why does the above error occour.??
ASKER CERTIFIED SOLUTION
Avatar of mkmccreary
mkmccreary

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial