Hello All,
I tried to search the issue, and found it as well but couldn't understand it very well. Sorry about that but since I am a beginner in Access, so I expect you will forgive me to ask it again
I have created two DBs, one Back End, and one FrontEnd. My FrontEnd contains all the UIs/Forms, Linked Tables, and the queries fetching data from linked tables, and the Back End consists of all the Tables.
Now, in my Model, the BackEnd DB will be stored in a common drive and will be accessed by multiple users through same FrontEnd.
Now when I am trying to fire a query in FrontEnd (aka FE) DB, it is locking up the Back Up database. Even though I have set the RecordLock property to No Locks to query and the form.
Can you please suggest how to remove the locking? I couldn't very well understand the solutions provided by other threads here so any explanation would be highly appreciated!
Thanks,
Vikas B