473,399 Members | 3,106 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,399 software developers and data experts.

Database closes itself

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.
Nov 13 '05 #1
2 2886
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**********@yahoo.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.


Nov 13 '05 #2
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**********@yahoo.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.

Nov 13 '05 #3

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

Similar topics

3
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...
2
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...
5
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...
4
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...
6
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...
35
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...
4
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...
4
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();...
3
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...
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: 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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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
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...
0
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...

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.