By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Prevent locking of frontend application when a report is opened in design mode

P: 33
Hello everyone,

I have a database that is split into front-end and back-end. When a report is opened in the design mode (back-end) and a user tries to open the corresponding form in the front-end, they get a message 'state unable to open or lock per admin'. Is there a way to prevent it other than getting out of the design mode when user is entering data in the forms. I appreciate any suggestions.

Mar 3 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
Why is the report in the back end? Forms, reports and queries belong in the front end. Only tables with the data belong in the back end.

Linq ;0)>
Mar 3 '10 #2

P: 33
Okay that sounds right. I just started making these queries and reports in the backend and really never thought about what you just mentioned. So I guess I will just export all the reports and queries to the front-end and that should solve the problem! I am just two months old in Access...i guess that's obvious here. Thanks again.
Mar 3 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.