Share via

ACCESS QUERY

Anonymous
2018-10-10T17:10:24+00:00

after creating my tables in access, i did the relationships. but if i try to do the query from different tables, it displays this message( The wizard is unable to open your query in datasheet view, possibly because another user has a source table open in exclusive mode, your query will be opened in design view.)

i have close all the table too but still the same message. what should i do then?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2018-10-10T20:02:39+00:00

    Could someone else have the database open? If not, close the database and make sure the laccdb is closed. If not, delete it. Or reboot your PC.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments