Results 1 to 8 of 8
  1. #1
    Vita's Avatar
    Vita is offline Competent Performer
    Windows 10 Access 2002
    Join Date
    May 2022
    Location
    Massachusetts, USA
    Posts
    296

    Can't delete, cut, or paste any objects in 2019 but in 2000 it works fine?

    I have an old database that uses an MDW. I am logged in with the admin user but delete, cut, and paste are all greyed out on right click and pressing delete on the keyboard does nothing.


    This only happens in Access 2019, if opened in Access 2000 I am able to use these functions fine (albeit at the lack of hundreds of other features).
    I tried opening the DB while holding shift already to no avail so I thought it may be something with the MDW however I cannot find any help for this issue.

    Thanks for any help!

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,568
    Perhaps look at some of these links?
    Can you import to a accdb DB?

    https://www.google.com/search?q=use+...hrome&ie=UTF-8
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Vita's Avatar
    Vita is offline Competent Performer
    Windows 10 Access 2002
    Join Date
    May 2022
    Location
    Massachusetts, USA
    Posts
    296
    Quote Originally Posted by Welshgasman View Post
    Perhaps look at some of these links?
    Can you import to a accdb DB?

    https://www.google.com/search?q=use+...hrome&ie=UTF-8
    Unfortunately I cannot import it as a majority of users use Access 2000 and can't/won't upgrade.
    I have no issue using the MDW and my user seems to have all the same permissions that the admin account does.
    I am not sure why it doesn't let me delete, cut, or paste anything.

    I suppose for this one experiment I could import it to an accdb but it wouldn't solve the issue for the future.
    If there is any more info I can give you to help deduce the issue then let me know.
    I am able to modify records and run queries still too, even create new objects.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,568
    Never used a MDW file so cannot comment further. Sorry.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Vita's Avatar
    Vita is offline Competent Performer
    Windows 10 Access 2002
    Join Date
    May 2022
    Location
    Massachusetts, USA
    Posts
    296
    Quote Originally Posted by Welshgasman View Post
    Never used a MDW file so cannot comment further. Sorry.
    I appreciate the effort! Hopefully someone will come along with an answer. My temporary fix is that I just close out the db and open it in 2000 to delete etc then go back to 2019.

  6. #6
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,158
    An MDW file is a security file.
    Have a read here which might explain why it locks everything up.
    https://www.lifewire.com/mdw-file-2621978
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,939
    Have you seen this link?

    https://stackoverflow.com/questions/...-2010#18131548

    Depends what you want to do when editing but there are significant differences between a mdb and accdb. Different versions of vba, commandlines etc - the latter probably being the one causing your issues

  8. #8
    Vita's Avatar
    Vita is offline Competent Performer
    Windows 10 Access 2002
    Join Date
    May 2022
    Location
    Massachusetts, USA
    Posts
    296
    Quote Originally Posted by CJ_London View Post
    Have you seen this link?

    https://stackoverflow.com/questions/...-2010#18131548

    Depends what you want to do when editing but there are significant differences between a mdb and accdb. Different versions of vba, commandlines etc - the latter probably being the one causing your issues
    I attemped to use the command posted to join a work group "DoCmd.RunCommand acCmdWorkgroupAdministrator" and then browsed for my mdw file but it appears to have changed nothing.
    I believe it is setup right since it prompts me to log in upon opening the DB.
    This is my shortcut target string. (S: is a network drive)
    "C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" "S:\Username\Projects\Database Dao Remake\DaoRemake.mdb" /WRKGRP "S:\Username\Projects\Database Dao Remake\Secured.mdw"
    Last edited by Vita; 05-19-2023 at 10:24 AM. Reason: removed color coding from the DoCmd

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

Similar Threads

  1. Replies: 9
    Last Post: 12-10-2020, 10:42 AM
  2. Replies: 12
    Last Post: 06-08-2017, 12:28 PM
  3. Replies: 5
    Last Post: 12-15-2015, 04:01 PM
  4. Replies: 1
    Last Post: 11-14-2014, 05:12 PM
  5. Replies: 6
    Last Post: 10-15-2014, 02:45 PM

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
  •  
Other Forums: Microsoft Office Forums