473,396 Members | 2,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

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
Mar 3 '10 #1
2 1595
missinglinq
3,532 Expert 2GB
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
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

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

Similar topics

1
by: Vikky | last post by:
Hi All: I have a problem with DB2 locking scheme. I am dealing with two processes modifying the DBMS (here IBM DB2 7.1 FP8 on Solaris) simulteneously. P1: Huge transactional data being...
4
by: Jeff | last post by:
I have a need to open a report in design mode immediately before opening it in preview, to change the Minimum and Maximum scale on an axis on a chart. This results in a flash of the report in...
7
by: Douglas | last post by:
I have a frontend and backend database , program.mde and data.mdb on a client PC. How do i prevent them launching the program.mde more than once on a single PC? Somtimes they minizmise the program...
2
by: Peter | last post by:
(I've tried this Q in the ms forums without response. See how it goes here.) Using A2003 but I guess this is not version-specific... If I want to implement row/record level locking on a split...
1
by: eskil | last post by:
Hi, I have an invoice which is being printed on two different trays. This is being done by some simple code in VB, and it works. However, my report goes into design mode in order to change the...
5
by: Charles Law | last post by:
Sorry for reposting this question, but I did not get a single answer last time, and I'm sure you guys must have some thoughts on the matter. I have a user control which can be dragged and dropped...
4
by: vermutmb | last post by:
I must be missing something, but I have a report that when it is opened programmatically as a Preview, there is a limited toolbar which prevents the ability to edit the design, among other things. ...
2
by: jphelan | last post by:
Ever since I successfully applied some techniques for increasing the speed of my 17 meg. Application; it has only made me hunger for more. First, let me list what I have done so far: 1. Split...
0
by: mungerer | last post by:
Whenever I am debugging a (desktop) application the Visual Studio 2005 IDE "locks" the design mode of any HTML files that I have open, even if they are not in the solution being debugged and are...
11
by: Gord | last post by:
When I open a certain report, it runs some code that generates the records that will be displayed in that report. This works fine. When I go to print preview the report it appears that the code...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.