I have a problem.
In two cases the access database is closing completely (but leaves the .ldb
file behind.).
I just added a new form and now when I switch from the design view to the
preview via the icon button it closes the whole database. It does not always
happen, but repeatingly. The second occasion is when I am in the Viasual
Basic code and want to save something and compile it, then it is closely
itself completely, too.
I check my code, there is no closing command for once in a procedure or
function in the specific form. And after it does not close ony that form but
the whole database - could it be a bug? Or what did I make wrong or forgot
to consider.
If anybody can help me, I would really appreciate it. 2 2903
nicole,
Sounds like a fatal error condition, IOW a bug in one of the
libraries, maybe a dll conflict on your system.
Suggestions:
Check your computer's system logs (under admin tools) to see whether
an event is logged for the crash. If an event is logged the info may
be a starting place.
Also search the MS support kb and see whether there is a crash problem
for your version.
Make sure you have the service packs for your version of Windows and
your version of Access.
Write some application level on exit code that just pauses the exit so
maybe you can bring up a debug window and see what's going on.
Alternatively, write an application level error logger so maybe you
can log the error to a file, especially if the system logs aren't
locating the crash for you.
HTH,
Elaine
On Fri, 25 Mar 2005 11:16:43 -0500, "nicole" <nb**********@y ahoo.com>
wrote: I have a problem. In two cases the access database is closing completely (but leaves the .ldb file behind.). I just added a new form and now when I switch from the design view to the preview via the icon button it closes the whole database. It does not always happen, but repeatingly. The second occasion is when I am in the Viasual Basic code and want to save something and compile it, then it is closely itself completely, too. I check my code, there is no closing command for once in a procedure or function in the specific form. And after it does not close ony that form but the whole database - could it be a bug? Or what did I make wrong or forgot to consider. If anybody can help me, I would really appreciate it.
Hello Nicole,
I had the same problem. I have reduced the occurence of this problem
dramatically by converting the database format from AC2K to AC2002-2003
db-format, while working in Access 2002/XP
In the mean time save your work a lot. In the beginning when I experienced
this it costed me a lot of developing time.
Bye, Wilbert
"nicole" <nb**********@y ahoo.com> schreef in bericht
news:jP******** *********@fe04. lga... I have a problem. In two cases the access database is closing completely (but leaves the .ldb file behind.). I just added a new form and now when I switch from the design view to the preview via the icon button it closes the whole database. It does not always happen, but repeatingly. The second occasion is when I am in the Viasual Basic code and want to save something and compile it, then it is closely itself completely, too. I check my code, there is no closing command for once in a procedure or function in the specific form. And after it does not close ony that form but the whole database - could it be a bug? Or what did I make wrong or forgot to consider. If anybody can help me, I would really appreciate it.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sven Jacobs |
last post by:
Dear newsgroup,
I've upgraded to PEAR::DB 1.6.5 recently. Unfortunately now the database
connection doesn't work as expected anymore :( The problems seems to be the
method disconnect(), which now closes the database connections of _all_
database objects. I ask myself if this is intentional or a bug. Below a
code example:
01 <?php
02 error_reporting(E_ALL);
|
by: RipTide |
last post by:
Background:
Using an unsupported/abandoned multi-user multi-database program that uses
Access 97 and Jet 3.5. Program itself appears to have been built with
PowerBuilder 6.5.
Databases reside on an NT 4 SP6 file server with opportunistic locking disabled.
Workstations are Win98 SE with Access 97, Jet 3.5 SP3, and Network
redirector file caching disabled (VREDIR/DiscardCacheOnOpen=1)
Network: Local LAN using NETBUEI as Primary Protocol,...
|
by: Chand |
last post by:
Private Sub tbDate_AfterUpdate()
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
rst.CursorLocation = adUseClient
Set cnn = CurrentProject.Connection
rst.Open "SELECT * FROM Table1 ORDER BY StudentID ASC", cnn,
adOpenStatic, adLockReadOnly, adCmdText
|
by: Riley DeWiley |
last post by:
I am using Jet 4.0 through OLEDB and C++.
My travails with compaction are well known to regular readers of this NG.
Many of my problems were solved by disabling record locking.
I am now confronted with two remaining mysteries, which I suspect are
related:
-------------------------------------------------------------
The Mystery of the Zombie Session (a horror story)
|
by: bbcrock |
last post by:
Unfortunately my users are demanding this functionality:
They are on a form. Click on an "add" button. An html window pops up.
They add a new item that is saved to the database. The window closes.
The HTML select box REFRESHES itself with the new informaiton (Primary
key and text field) WITHOUT submitting the form.
I tried to get away with a text box on the form that would dynamically
repopulate the select box, but no-go- they want to...
| |
by: Terry Jolly |
last post by:
Web Solution
Goal: Have a global database connection
Why: (There will be 30+ tables, represented by 30+ classes) I only want to
reference the database connection once.
I put the connection string in the web.config.
I created a class with a static database connection and the class opens and
closes the database.
|
by: -pb- |
last post by:
I am using .NET 2.0 along with Data Access Application Block of
Enterprise Library 2.0 in one of my wrapper class and what I observered
is once the connection is left open after execution of ExecuteDataSet
function of Database class.
I used Preformance counter for SQL user connection. When
DataFactroy.CreateDatabase is executed it create a connection but when
Database.ExecuteDataset doesn't closes the connection. Furthermore, if
I close...
|
by: badaczewski |
last post by:
The following javascript appears on a popup window.
<script language="javascript" type="text/javascript">
function InsertContact(value)
{
window.opener.CallBackContact(value);
window.close();
}
</script>
|
by: Johnson |
last post by:
I'm not sure if this is an IIS 5.1 issue or ASP.NET issue, or Visual Studio
2008 issue -- thus posting to 3 groups. Please don't be offended.
The problem I'm encountering is that Visual Studio closes unexpectedly and
without any error message being displayed, or error messages written to the
system logs. Visual Studio closes when I attempt to open an ASP.NET Web
application (not Web site) solution for which IIS is set as the project's...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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,...
|
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...
|
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...
|
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...
|
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();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |