Results 1 to 4 of 4
  1. #1
    ldesiano is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    1

    "Could not use . . . . file already is use"

    I am on Windows 10, Build 1903, MS Office Pro Plus 2019 - 64 bit


    Working on a stand alone, single user laptop. I am the admin

    I cannot perform any of these tasks;
    Compact & Repairs
    Back Up Database
    Save the DB with a different name to any folder
    Save As to a different directory
    Save As with a different DB format

    but these tasks can be executed without issue on a friend's laptop (also Win10 with Office 2019) using the same file.
    In all cases I get the error "Could not use . . . . file already is use"

    I've read a number of articles and threads but have not come across anything that describes what I have.


    Database is NOT split and it is NOT on a server. Running standalone


    When I open an Access DB the laccdb file DOES get created, so it's not create access issue. I notice that the laccdb file disappears when I perform any of the above tasks, but immediately comes back when I clear the error message.



    Any advice or direction would be greatly be appreciated

    Larry

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,736
    These can be tough to solve. Did you open the laccdb file you speak of to see how may entries are in it? IIRC, all of these operations require Access to close the db, perform the operation and then re-open the db. If the lock file has 2 entries in it, one of them is a left over if no one is actually in it. I haven't seen this happen when the db is in a local directory but I have seen issues with the lock file when the db is in a network directory, even when not split.

    I'm assuming there are no folder permissions issues for you (you need the whole 9 yards - create/read/write/modify/delete) and that it's not about Trusted Locations either.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,309
    Sometimes stuff just breaks inside. Maybe create a new Blank database, then import everything from original and see if it all works and you can perform those functions?

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,736
    Quote Originally Posted by Bulzie View Post
    Sometimes stuff just breaks inside. Maybe create a new Blank database, then import everything from original and see if it all works and you can perform those functions?
    But the same file works for someone else? Or did I misunderstand that part? Don't think you can have corruption for one person and not another.

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

Similar Threads

  1. Simple table relationships ("faces" to "spaces" to "chairs")
    By skydivetom in forum Database Design
    Replies: 36
    Last Post: 07-20-2019, 01:49 PM
  2. Replies: 1
    Last Post: 02-03-2019, 09:16 AM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. "Could not find file <file path." - Error 3024
    By jmitchelldueck in forum Access
    Replies: 4
    Last Post: 07-30-2015, 02:15 PM
  5. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM

Tags for this Thread

Posting Permissions

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