Lccmdb and ldb files: Difference between revisions

(6 intermediate revisions by 2 users not shown)

Line 1:

When and Access program is opened it creates a "lock file" with the same name as the parent file but a different extension. This file shows access that either the parent program is opened or closed with problems.

* .mdb files generate file with .ldb extension (eg. CCMDB.~~mdb~~ will generate file CCMDB.ldb)

* .mdb files generate file with .ldb extension (eg. CCMDB.accdb will generate file CCMDB.ldb)

* .accdb files generate a file with .lccmdb extension (eg. PHI Loader.accdb will generate file PHI Loader.lccdb)

Line 9:

== Instructions how to remove lock files ==

# check file properties (right click) ownership

# get ~~the person who is~~ the owner to close out of any open parent program

#* click on security tab

# if lock file still there, get them to open and then close parent program

#** click on Advance tab

# if lock file still there, get them to re-boot their computer

#***click on Owner tab

# if lock file still there, get them to try to delete the file manually

# get the owner to '''close out of any open parent program'''

# if lock file still there and it is on a network drive, send a ticket to the helpdesk to get the file deleted

#* the error often happens during [[sending]]; in that case, the owner of the file should close out of [[CCMDB.accdb]], follow [[Breaking out of a frozen program]] to make sure no hanging instances remain, then open [[CCMDB.accdb]] again and send again

# if lock file still there, get them to '''open and then close parent program'''

# if lock file still there, '''end the task''': open task manager (ctrl-shift-esc), find any Microsoft Access entries, right-click, end task them (make sure you don't also have another access program open at the same time)

# if lock file still there, get them to '''re-boot their computer'''

# if lock file still there, get them to try to '''delete the file manually'''

# if lock file still there and it is on a network drive, '''send a ticket to the helpdesk to get the file deleted'''

== rights ==

* 2025-07-22 - email saying "permissions set nominally" - whatever that means... Task# 638500 - Access Lock File Permission Issue — Request for Folder ACL Adjustment | TTENBERGEN@hsc.mb.ca for Service Request REQ496796

* 2025-06-30 - suspect problem is that the lock files appear to be generated with single user ownership that others then can't delete; sent email to service desk to get folder rights tweaked to allow our entire team to delete these.

[[Category:IT Instructions]]

@@ Line 1: / Line 1: @@
 When and Access program is opened it creates a "lock file" with the same name as the parent file but a different extension. This file shows access that either the parent program is opened or closed with problems.
-* .mdb files generate file with .ldb extension (eg. CCMDB.mdb will generate file CCMDB.ldb)
+* .mdb files generate file with .ldb extension (eg. CCMDB.accdb will generate file CCMDB.ldb)
 * .accdb files generate a file with .lccmdb extension (eg. PHI Loader.accdb will generate file PHI Loader.lccdb)
@@ Line 9: / Line 9: @@
 == Instructions how to remove lock files ==
 # check file properties (right click) ownership
-# get the person who is the owner to close out of any open parent program
+#* click on security tab
-# if lock file still there, get them to open and then close parent program
+#** click on Advance tab
-# if lock file still there, get them to re-boot their computer
+#***click on Owner tab
-# if lock file still there, get them to try to delete the file manually
+# get the owner to '''close out of any open parent program'''
-# if lock file still there and it is on a network drive, send a ticket to the helpdesk to get the file deleted
+#* the error often happens during [[sending]]; in that case, the owner of the file should close out of [[CCMDB.accdb]], follow [[Breaking out of a frozen program]] to make sure no hanging instances remain, then open [[CCMDB.accdb]] again and send again
+# if lock file still there, get them to '''open and then close parent program'''
+# if lock file still there, '''end the task''': open task manager (ctrl-shift-esc), find any Microsoft Access entries, right-click, end task them (make sure you don't also have another access program open at the same time)
+# if lock file still there, get them to '''re-boot their computer'''
+# if lock file still there, get them to try to '''delete the file manually'''
+# if lock file still there and it is on a network drive, '''send a ticket to the helpdesk to get the file deleted'''
+== rights ==
+* 2025-07-22 - email saying "permissions set nominally" - whatever that means... Task# 638500 - Access Lock File Permission Issue — Request for Folder ACL Adjustment | TTENBERGEN@hsc.mb.ca for Service Request REQ496796
+* 2025-06-30 - suspect problem is that the lock files appear to be generated with single user ownership that others then can't delete; sent email to service desk to get folder rights tweaked to allow our entire team to delete these.
 [[Category:IT Instructions]]