473,785 Members | 2,738 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Forms freezing

Pat
I'm having some problems with forms freezing up on me.

I have a front end linked to tables in 2 back ends. Users can open a form
(quotes) which is linked to
a table in be1. while adding a record to this form, the user can open a
form (stations) linked to a table in be2 which will generate a price, text
etc and insert info back into first form (quotes). This works.

The problem is that every so often the user opens the 2nd form in order to
update (change something)
and when he closes it, the 1st form freezes. - all the code runs, the info
on the first form is updated,
no error is generated, but the program is just frozen. you have to close it
(through taskmaster) and restart again in order to get access again.

Could the 2 different back ends be causing this. Does linking to different
be's from the same front end
cause issues?
Apr 26 '06 #1
2 4375
Pat wrote:
I'm having some problems with forms freezing up on me.

I have a front end linked to tables in 2 back ends. Users can open a form
(quotes) which is linked to
a table in be1. while adding a record to this form, the user can open a
form (stations) linked to a table in be2 which will generate a price, text
etc and insert info back into first form (quotes). This works.

The problem is that every so often the user opens the 2nd form in order to
update (change something)
and when he closes it, the 1st form freezes. - all the code runs, the info
on the first form is updated,
no error is generated, but the program is just frozen. you have to close it
(through taskmaster) and restart again in order to get access again.

Could the 2 different back ends be causing this. Does linking to different
be's from the same front end
cause issues?


No, using 2 backends is probably not causing this. Is the problem repeatable?

I'd try using debugging and step through your code. Perhaps there is some type of
unhandled error or an endless loop.

Perhaps one of the forms is corrupted or even the .mdb is corrupted.

Have you tried Compact and Repair (on a backup of your .mdb)?

Things get more drastic from there. You might need to import objects into a fresh .mdb
file or use the undocumented /decompile or the Application.Sav eAsText() and
..LoadFromText( ) calls to remove corruption.

A search of this newsgroup will yield lots of assistance.

--
'---------------
'John Mishefske
'---------------
Apr 26 '06 #2
Pat
The problem does not occur when a new record is created, but if form 2 is
used to update a record
the problem will occur at about 1 or 2 times every 10 times this is done. I
know that all of the
code has executed because the form 1 closes and form 2 refreshes, but the
user just can't access anything on the open form (1). not even the close
window x in the top of the window.

both backends have be compact/repaired. front end also

"John Mishefske" <jm**********@S PAMyahoo.com> wrote in message
news:Wk******** ******@tornado. rdc-kc.rr.com...
Pat wrote:
I'm having some problems with forms freezing up on me.

I have a front end linked to tables in 2 back ends. Users can open a form (quotes) which is linked to
a table in be1. while adding a record to this form, the user can open a
form (stations) linked to a table in be2 which will generate a price, text etc and insert info back into first form (quotes). This works.

The problem is that every so often the user opens the 2nd form in order to update (change something)
and when he closes it, the 1st form freezes. - all the code runs, the info on the first form is updated,
no error is generated, but the program is just frozen. you have to close it (through taskmaster) and restart again in order to get access again.

Could the 2 different back ends be causing this. Does linking to different be's from the same front end
cause issues?
No, using 2 backends is probably not causing this. Is the problem

repeatable?
I'd try using debugging and step through your code. Perhaps there is some type of unhandled error or an endless loop.

Perhaps one of the forms is corrupted or even the .mdb is corrupted.

Have you tried Compact and Repair (on a backup of your .mdb)?

Things get more drastic from there. You might need to import objects into a fresh .mdb file or use the undocumented /decompile or the Application.Sav eAsText() and .LoadFromText() calls to remove corruption.

A search of this newsgroup will yield lots of assistance.

--
'---------------
'John Mishefske
'---------------

Apr 26 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

57
3619
by: Egor Bolonev | last post by:
why functions created with lambda forms cannot contain statements? how to get unnamed function with statements?
0
916
by: Nick Rogers | last post by:
After about two months of using Visual Basic . NET 2003 Standard, it suddenly started freezing up whenever it tried to display a Windows form inside a project file. All other files, such as HTML and XML, open hunky-dory, including projects without forms in them. I tried reinstalling the software, uninstalling and installing again, reinstalling the .NET Framework (an hour ago) I also cannot create new projects. Has this ever happened to...
13
2470
by: Ioannis Vranos | last post by:
Why in this code the form *does not refresh* when it gets the focus/after some time? #using <mscorlib.dll> #using <system.windows.forms.dll> #using <system.dll> #using <system.drawing.dll>
1
1357
by: boB | last post by:
When I try to run a program - any program - my environment all of a sudden starts freezing up. Even an empty solution. It will build, but never run the built program and the GUI won't respond and needs to be killed with Task Manager. It was running fine until I experimented with VBPowerPack copying it into a current folder instead of using Copy Local. Now, even after deleting it completely, I'm frozen no matter what. To make matters worse,...
10
2019
by: MaRCeLO PeReiRA | last post by:
Hi All, After PostgreSQL freeze some times, I am moving from 7.3.4 to 7.4.1, trying to solve this problem. When the daemon get frozen, I can't even use psql to browse a database (as if the database was down for some reason, or the daemon is not running). In these cases, a "pg_ctl -D /var/db stop" followed by
7
2042
by: bearophileHUGS | last post by:
Most of my ideas seem usless or stupid, but I think expressing them here doesn't harm much. This is an idea for Py 3.0, because it's not backward compatible. Dicts and sets require immutable keys, like tuples or frozensets, but to me they look like a duplication. So the idea is to remove tuples and frozensets (and replace the few other uses of tuples with lists, like the % interpolation), and to add a freeze operation, to freeze lists,...
6
2816
by: hem | last post by:
Hi, I have the following small program which read password from user after echoing off. But the problem is, it is freezing for some time (not sure about the duration) before going to the next statement and I have to press "enter" multiple times (maximum 4, it is not consistent though). I am trying it on a hp-ux machine with aCC compiler. Any pointers/help would be greatly appreciated.
0
1003
by: Ivovh | last post by:
Since this morging I have a problem with VS .NET 2005. Evertime when it hits a breakpoint my whole computer freezes. I have to reset it to work again. Before it always worked fine and I didnt do anything special today what could have caused this problem. I tested it in a new project and it gave the same situation. In VS 2003 I still can hit breakpoints without freezing Any solutions?
2
2439
by: julietmachiwa | last post by:
I purged my database and rebuild indexes. The system has started hanging/freezing. Some Forms are not working & some select statement & Procedures are also not running. All these were OK before. On error messages are coming. What can be the cause and Solution . Using Oracle 8. Have tested with Database tools , the system hangs if you highlight some the procedures. These procedures compile well thru SQL Plus. !!Pliz help !!!!
0
9643
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
10087
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9947
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8971
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7496
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5511
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3645
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2877
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.