Results 1 to 7 of 7
  1. #1
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100

    Unable to Open Access Files

    Hi, when I double-click an Access file within Explorer, another separate file (link?) appears with a little lock in the corner preventing me from opening the file. Would anyone know what's causing this. See image below. Thanks.

    Click image for larger version. 

Name:	Access_2019.06.15_12h51m10s_005_.png 
Views:	17 
Size:	4.1 KB 
ID:	38751

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    you're not showing the file extension. Is it TemplateAssetManager.laccd? If so, it is the database locking information file. When you close db, Access should automatically delete it.

    Just clicked - you are prevented from opening which file?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100
    Hi Micron, yes, the extension is .laccdb. but it only appeared after I clicked the .accdb file first.

    If I open Access then the file, Access opens it fine. And when I close the file using Access the 1k locked file vanishes. It seems I should only open my files after Opening Access first. Thx.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I don't understand what your problem is/was. The lock file appears whether you open Access first and select the file, or open the db from Windows file Explorer.
    Then when you close Access, lock file is deleted regardless of which way the database. Perhaps by not displaying your file extensions in Explorer you were trying to open a db that is already open? Without the extension how would you know which is which?

  5. #5
    DigitalAdrenaline is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    100
    Micron, I used to be able to click an Access file and it would just open in Access, but now when I click a file, nothing happens except a new file appears of the same name with a lock on it. I'd not had that happen before. Maybe it's something new that happens with the latest upgrade. Not sure.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You may have a hidden instance of Access open. Suggest you check carefully in Task Manager and if you find any listings for MSAccess, end the task.
    Alternatively reboot and then try again.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    fer sure it's not an Access problem but a Windows one. I'm no expert there, and you might be better off using a search term to research your issue. Could be as Colin says, or there might be a setting to open an application minimized. I know that is an option for shortcuts but I don't think it applies to files opened from File Explorer. If you find an instance of Access running in task manager, it's might be because you just opened a database. I would not suggest you use that method to close Access unless you are fairly certain it's not there because you opened a file.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 09-09-2015, 09:42 AM
  2. Unable to open Access Form
    By kris24 in forum Forms
    Replies: 1
    Last Post: 03-24-2014, 05:07 PM
  3. Access 2.0, unable to open database
    By Raul in forum Access
    Replies: 8
    Last Post: 01-20-2014, 06:23 PM
  4. Replies: 12
    Last Post: 07-25-2013, 12:49 PM
  5. Unable to open Access on Local Area Network
    By MikeWaring in forum Security
    Replies: 1
    Last Post: 12-24-2010, 11:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums