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

[mulamootil]

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.

Thanks
Stan

[missinglinq]

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)>

[mulamootil]

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.