My Database Has Started Crashing! HELP!

Sep 22, 2006

I am a novice database user and I built a small job tracking database for a small construction company. For the last 2 days, Access has become very unstable and I am getting the "Sorry but Access has to close" message shortly after opening. I have tried the "repair and compact" utility but no change and it still crashes. Is there other troubleshooting procedures that I can use or can you recommend someone to do the repair work?

View Replies


ADVERTISEMENT

Database Crashing!

Feb 23, 2006

I've come across a problem with my database, I’ve tried everything I can think of, and I’m still no wiser as to what’s causing the crashes. I hope someone can shed some light on what the problem might be.

I've created a database that uses a switchboard to navigate through the various forms, the switchboard is loaded (using the start up options) most of the database objects are switched off (like display database window), apart from 'allow full menus' and 'allow default shortcut menus'.

This reason I’ve given you the above information is that the error only occurs when the database is loaded through the start up options.
If I open the database bypassing the start-up options this error doesn't occur.

Now to the error:

I have various forms that have a button that will attempt to send an e-mail, its set up that the email doesn't send automatically but allows the user to edit the email before sending.
When the e-mail is created using the code below, and the user decides to cancel sending the email by pressing the 'close' button on the email, the database will lock up.

The first error message I get is:

The sendobject action was cancelled
You used a method of the DoCmd object to carry out an action in visual basic, but then clicked cancelling a dialog box.
For example, you used the close method to close a changed form, then clicked cancel in the dialog box that asks if you want to save the changes you made to the form.

The second message is my error trapping for cancelling the email, and then after that the form loses focus and I can't do anything to the database. It's still running because I have a clock on my form that’s still ticking away.

The only way I can close my database is to 'ctrl alt del' and 'end task' it. When I do this I get another error message saying

You can't exit the database now
If you are running a visual basic module that is using OLE or DDE, you may need to interrupt the module

And then the database closes.
I've noticed the crash only occurs when the 'display database window' option is turned off.
When its on then my error trapping deals with the closing of the email.

Private Sub MailCreditReport_Click()
On Error GoTo Err_MailCreditReport_Click
Dim stDocName As String

If Me.Dirty Then
DoCmd.RunCommand acCmdSaveRecord
Else
End If

stDocName = "rptCreditAuthorisation"
DoCmd.SendObject acReport, stDocName, acFormatRTF, , _
, , , , True, False

Exit Sub

Exit_MailCreditReport_Click:
Call ReportError
Exit Sub

Err_MailCreditReport_Click:

Select Case Err.Number

Case "2501"
MsgBox "User cancelled Sending E-mail(s). Please Resend", vbExclamation, "Sending Stopped"
Exit Sub
Case Else
Resume Exit_MailCreditReport_Click
End Select

End Sub

I've tried various things with the code like DoCmd.CancelEvent, but nothing seems to make any difference.

Any help would be greatly appreciated.

View 11 Replies View Related

Would Like Some Help With Crashing Database

Oct 30, 2007

Anyone,
I posted at the begining of this month with an URGENT post and had a lot of help off some of you guys. My database was corrupting and crashing and I had a lot of help of rural guy and others. By the finish of the two days I had compiled and decompiled my database and lots of other little tricks to try and make it a bit better.

At the end of the two days the database was up and running but I had to delete three of my forms because the VB Script that was attached to them forms would not delete. I managed to get it working but I am now having further problems.

Althought the database is useable without these forms I can not re-create them. I have tried importing them into a new database, compiling them then importing them into the FE, but it still crashes. I have also tried just creating a new form and starting from scratch but it will not let me create a new form from scratch. It runs very slow and still crashes on development. my Back-end is working fine.

Does anyone know of any common errors that may be causing these problems. I am now in discussions with my boss because the only thing I can think of doing is starting my FE front scratch.

Any sugggestions

View 5 Replies View Related

Need Help Getting Started...

Feb 9, 2007

I'm fairly experinced with computers... and I'm a quick learner... so lets get started...

I need to make a library of information. This information will then be used in a clinical note.

What I want the form to do is this:

The form will have a place where you can choose a 'Doctor's Diagnosis.' Once you select the Doctor's Diagnosis, in this case lets say we selected 'Arthritis' Below in a new drop down box or something of that sort, It will be the 'Nurse's Diagnosis' and it will give you a diagnosis according to what was selected under Doctor's Diagnosis. Once you select something from the Nurse's Diagnosis box, It should give you the apporpriate information according to what you have selected. Basically what I need is for the form to only display the information according to what the user inputs under Doctor's Diagnosis and Nurse's Daignosis. A good example of this would be, Lets say we are on a website it asks for 'Country,' you select 'United States' then under that it has another drop down box and it asks you to select state and it gives you the states of the United States. But if u where to select Canada it would give you the states of Canada.

Can Someone please give me some direction to follow and give me some good info on this because i am completely lost.

View 1 Replies View Related

Can't Get Started

Apr 28, 2005

Good morning,

I am trying to create a simple form that will run reports based on certain criteria.

I have two plans (MD and DC) and I want the user to be able to select whether they
want to run MD reports or DC reports. After that selection, I want them to select
the period (Jan - Mar so far). Based on the two criteria above, I want the appropriate
tables/queries to load so that they can run the specific reports. Each month has it's own
table, so I have six tables all together (MD: Jan, Feb, Mar and DC: Jan, Feb, Mar).

So far, all I have is a table with the plan and the period, in the same table. Can anyone
please point me in the right direction as to how I should approach this?

Thank you!

View 5 Replies View Related

Table Help -- Getting Started

Jul 13, 2006

hello,

I am having some difficulty starting my database. I have worked with Access 2002 and have massaged data into useful information for other databases. I am having trouble determining useful tables and eliminating redundancy. I have attached a.bmp file.

So far I have 20 different "Features". Each one of these features can belong to one or more "Groups". Each "Group" for a particular "Feature" will have a selection list of Multiple "Causes" a user can select from. Once the user selects a "Cause" -- then each "Cause" has a list of "Corrective Actions" the user can select particular to that "Cause".

If anyone would be so kind as to possibly point me in the right direction as to what I should do as far as structuring my tables properly, I would be appreciative. Thank You in advance.

View 7 Replies View Related

Getting Started W/ Access

Apr 11, 2007

Hi, I'm trying to scope a MS Access project and was wondering if VB programming/ is required to build something like the Northwinds sample database?


We'd like a DB system to manage member records, their administrators and to query for random member mailings.


Does Access 07 have easy ways to generate individual or group mailings or does this always come through MS Word mail merge? Our data will be shared on a MYSQL server.Will RAND and SELECT WHERE SQL statements be enough for random sampling or will this require some outside programming? Are the form controls easy to use generating custom reports?


Thanks for any help getting started or finding resources.

View 1 Replies View Related

How To Get Started With Access/Web Development

Aug 26, 2005

Hello:

I've been using Access as my database development tool for a few years. Now I would like to start learning how to use Access in conjuction with other tools (such as ASP, vb.Net, etc.) to develop web applications. Can anyone point me in the right direction, offer ideas on how to get started? I don't know how things work between an Access db and the Web.

Thank you very much.

Raneil

View 4 Replies View Related

How Did You Get Your Access Career Started?

Dec 13, 2005

Im just curious on how some of you made a career by creating DB's for clients. Everything I see is generally some other program besides Access. Is Access something I should not learn because there is no demand or is this strictly free lance work?

These past few months have captivated my imagination and I have enjoyed creating my database and all the countless times I learn something new. However Im to the point where I am asking myself if the hours and time spent learning all of this will be useless because I am contemplating the idea to make this a career (oddly enough I enjoy it that much!)

Thank you for the input!

John D

View 1 Replies View Related

Access Started To Hang

Jan 21, 2007

Hello,

I have a very strange problem.

A customer has come to me with a database that must have worked fine at some point (as it has lots of entries but hangs on startup) but all of a sudden its started to just hang (i.e. just get stuck - as if it were in an infinite loop (though I doubt this is the case).

The system is an MDB but it references an MDE as a function library - by walking through the code I located a line with a function that I am assuming comes from the MDE (as I cannot find it in the MDB) that causes the system to hang.

By commenting out this line (and I dont know what this line does exactly) the system becomes accessible and most functions work - however when I try to run a report it hangs again.

I have tried to walk through the report but it doesnt help as it still just crashes at a point that I cannot see.

I have tried compact and repair just incase thats something to do with it but its made no diffence

Any suggestions?

Thanks in advance

View 14 Replies View Related

DB Crashing

Jul 18, 2005

So here's my situation: Tonight I opened the file I was working on this morning (which was in perfectly fine state)...

I opened a form - CRASH!!
I press ALT+F11 to go to the VBA editor - CRASH!!
I open another form - it works fine... So i select a button and tried to edit the action script - CRASH!!
I relinked the backend file - CRASH!!
It seems everying I do makes the darn thing crash. :mad:

I tried compacting/repairing - no luck there. This is not the first time it has happened to me. I forgot how i managed to fix it the first time. Anyone with experience with this? Any suggestions?

I tried opening an older db file, and was able to access the VBA editor for that file. But it crashed again when i tried going back to the bad file.

If i recall correctly, I think this morning, when I closed my access file, I closed the Access Program long before I finally closed the VBA editor (didn't realize it was still around because the taskbar was a bit cluttered). Wonder if that caused it to go hay-wired.

View 3 Replies View Related

Access 2003 : I Need A Hand Before Getting Started

May 18, 2007

Hi all,


I need a hand from your side with the following.
The attached Excel workbook needs to be transformed into an Access 2003 database.
It is a list of clients’cases represented by lawfirms and the amount of money that is involved.
The case comes in under the ‘Aufstellung’ worksheet and can progress to a Claim or 2 different other Requests.
Purpose of the database :
1.Fast entry of new cases
2.Easy look up of existing cases
3.Conform updating of existing cases (warning when a certain case number already exists)
4.Easy report running
5.Keep the entire history of updates, changes, deletions and processing to a Claim
Tables :
1.Aufstellung
2.Claim Request
3.MB Request
4.MFA Request
-Question 1 : In the tables you will see that several different appointment dates and hours for one case are listed in 1 cell. In order to keep the history of updates do I need to create a separate Appointments table ? How would I structure this then ? The unique identifier is the Case Number. But 5 columns (Columns E, F, G, H and K) are ellegible to be treated this way. Do I need to create 5 separate Appointments tables ? And how do link them ?
-Question 2 : In order to split all the packed Appointments information in one cell I need to transfer the column to Word, replace the manual break by e.g. *, re-import the table in Excel and do text to columns ? So that each Case Number gets a number of columns accordingly to the number lines in the original cell ?
Queries :
1.List all Failed cases per form
2.List all Open cases per form
3.List all Filed cases per form
4.List all New Date set by Authorities per form
5.List all No results per form
6.List all ABC per form

Forms :
1.Aufstellung
2.Claim Request
3.MB Request
4.MFA Request
-Question 1 : How do I set up a check box in the Aufstellung form which, by checking off, will transfer the current record to the Claim Request form ?
-Question 2 : How can I make a field to be a lookup field ? e.g. When typing a name, it will give a drop down list of existing names of the table and the possibility to type a new name which will be stored in the table ?
-Question 3 : How do I make a pop-up warning message in the Austellung form when a certain case number exists already in the database ? And how do I block the case number field for duplicate entries ?
Reports :
1.Aufstellung complete table
2.Claim request complete table
3.MB request complete table
4.MFA request complete table
5.List all Failed cases per Form and include count of Failed cases plus sum of the Main demand in Euro
6.List all Open cases per Form and include count of Failed cases plus sum of the Main demand in Euro
7.List all Filed cases per Form and include count of Failed cases plus sum of the Main demand in Euro
8.List all New Date set by Authorities per Form and include count of Failed cases plus sum of the Main demand in Euro
9.List all No results per Form (empties) and include count of Failed cases plus sum of the Main demand in Euro
10.List all ABC per Form and include count of Failed cases plus sum of the Main demand in Euro
-Question 1 : How do I include a count of the records into the report ?
-Question 2 : How do I include a sum of the Main demand in Euro into the report ?

Switchboard :
1.Make a new entry or update an existing one
a.Aufstellung
b.Claim request
c.MB Request
d.MFA request
2.Search
a.Case Number
b.Applicant’s Name
c.Date
d.Court record Number
3.Reports
a.Failed case
b.Open cases
c.Filed cases
d.New date set by Authorities cases
e.ABC cases
4.History
a.Export history table to Excel through e-mail
b.Who updated the record and when ?
-Question 1 : Do I need to create a switchboard at the very beginning of my database ?
-Question 2 : A switchboard can only contain 8 buttons, how do I create a sub switchboard ?
-Question 3 : How do I set up the user access tracking – who updated what when ?

Thanks in advance !

View 1 Replies View Related

Access Keeps Crashing - Help!

May 1, 2005

I don't know if this is caused by Access (2003) itself, or somethign else, such as the JET drivers. Whenever I load up anything in Access it crashes saying I can repair it and restart access... no matter what I load.

Also, it seems other programs that connect to a database only retrieve 'nothing' from the tables and queries. I'm quite confused, any help would be wonderful right now.

Running on Windows XP SP2 with Access2003

View 5 Replies View Related

General :: Started Form Doesn't Work?

May 24, 2015

I have a DB: This DB was sent to me via eMail (dropbox). It consist in a BE and 3 FEs. In each of the FEs I have a started form with some code activated by the Open event.

The issue: Access do nothing when I open the FEs. Note please that the DB is designed by me and it work very well on the user"s computers.

I use A2007 on Win7

The DB is in a trusted folder. Compact and Repair is not useful.

View 14 Replies View Related

Time Difference Calculation - Job Started / Ended

Jan 30, 2014

I have a [Time Job Started] field that is auto populated with now(). which has input of 1/29/2014 11:02:02 am. Then I have a [Time Job Ended], typed in by user that has input of 6:00 pm, no date value. Cant really do the date() + Time Job Ended, because the date can range since times can go through midnight.

I am trying to calculate time duration. DateDiff("n",[Hot Calls]![Time Job started],[hot Calls]![Time Job Ended]) if this formatted as "Short time" it returns 0:00.

I want to report this as HH:MM. so the result should be 6:58.

View 5 Replies View Related

Code Keeps Crashing Access

Feb 15, 2005

on a small scale this code works, but when my inventory table has all of the 2000 records it crashes, any ideas.
I can ftp my database if needed

Code: Dim ColorDim StartPointDim RsItem As DAO.RecordsetDim RsNewItem As DAO.Recordset 'Grab the inventorySet RsItem = CurrentDb.OpenRecordset("select ItemId,Description1,description2,quantityonhand from item")'grab the table that will have the new item and description addedSet RsNewItem = CurrentDb.OpenRecordset("select * from newitems") With RsItem While Not .EOF StartPoint = 1Start:'find out if the last numbers is numeric or notIf IsNumeric(Mid(Right(.Fields!itemid, StartPoint), 1, 1)) = True Then'see if the start point is the last letter or notIf StartPoint = 1 Then 'meaning there is no colour indicated at the end of item Else'add the quantity and the color to the newItem tableColor = Right(.Fields!itemid, StartPoint - 1)RsNewItem.AddNewRsNewItem!Description = .Fields!quantityOnHand & ColorRsNewItem!itemid = .Fields!itemidRsNewItem.UpdateEnd If Else'move the startpoint to the next letter in itemStartPoint = StartPoint + 1GoTo StartEnd If .MoveNextWendEnd With

View 3 Replies View Related

Bound Reports Crashing DB

Dec 1, 2007

I've redeveloped my DB so that all forms are unbound. I did this due to a multiuser environemt of 30 or more users.

I left all reports bound because there were fewer than 10 concurrent users running them at any one time.

But... I'm finding the DB crashes when a second user runs the same report concurrently. Maybe its data binding overload?? Would setting the underlying query recordset type to snapshop overcome the problem??

I appreciate any ideas

View 6 Replies View Related

MS 2000 Access Application Is Crashing

May 30, 2005

My MS 2000 Access application is crashing and returns a msg something like this: "Your Access application caused an error and Access must be closed"
This occurs only when I execute some forms; always the same forms cause the problem.
Somebody told me to copy the .mdb to another place in my HD and change the names of the forms.
I did it and it always works well!
Any good reason for that?
My app is not yet splited in FE and BE. Splitting would help?

Thanks a lot

View 1 Replies View Related

Access Crashing Upon Import Of CSV Files

Aug 23, 2005

Every time I try to import a CSV file into my Access database it crashes. I've tried repairing it but the repaired database crashes as well. Any ideas on what could cause this?

Thanks.

View 8 Replies View Related

Novell Server Crashing Because Of Access 97

Apr 27, 2007

Hi. I have been fixing up some access 97 programs on the computer systems at my work. The main changes I made was creating a search function using a query behind a form to search the database (no more than only 90,000 records). I am running a novell server. The data tables are in a database on the server. The access program on the desktops have their own access database program that use linked tables to the data tables on the server. The following is my issue:

Apparently, some of the changes I made to the searches caused the server buffer to become full and not flush itself. Anytime I was working on creating the fixes, it seemed to make the server crash. I 'm just wondering if anyone has had a similar problem with access 97 running on a novell server and causing any buffer issues. Any ideas on how to prevent the server from crashing?

View 3 Replies View Related

Access 2000 Crashing When Using Frontend - Help.

Jun 28, 2007

Hi all, 1st post. I'm and Access n00b I'm afraid, so take it easy. I normally use php/mysql, but have been roped in to fixing a broken access database.

I've got an Access database, and a fileserver is holding the data (mdb file), but I've got around 10 machines which access the database thru a frontend (mdb file).

Now, this has been working fine until today, where I am trying to view one table (Orders), and access bombs out. It shuts down instantly with no warnings. It does this on every machine, so I think it is a database problem. I can view the data if I open the standalone data file, but I cannot view the data thru the frontend.

I need to fix this asap... what's causing the crash? I didn't make the front end, but if I could look at the code, I may be able to see where it's failing.

View 3 Replies View Related

Unable To Match If User Already Started A Record Using Date And Username

Aug 1, 2014

I am trying to match if a user has already started a record using the date and username. I have written the following code but I keep getting a error 94 about null. I know its an issue involving the date part. why this isn't working.

Code:
DLookup("TimeSheetID", "TimeSheet", "EmployeeID=" & Nz(Me.ListEmploy.Value) & " AND TimeSheetDate=#" & Date2 & "#")))
The full code

Code:

Dim Date2 As Date
Date2 = Date
If (Not IsNull(DLookup("TimeSheetID", "TimeSheet", "EmployeeID=" & Nz(Me.ListEmploy.Value) & " AND TimeSheetDate=#" & Date2 & "#"))) Then
lngEmployeeID = DLookup("TimeSheetID", "TimeSheet", "EmployeeID=" & Nz(Me.ListEmploy.Value) & " AND TimeSheetDate=#" & Date2 & "#")
DoCmd.OpenForm "frmTimeSheetMain", , , "TimeSheetID=" & Nz(lngEmployeeID), , , "NoTimeSheetID"

View 5 Replies View Related

FileDialog(msoFileDialogFolderPicker) Crashing Runtime Application

Jan 31, 2006

I'm attaching the code for a function that's attached to a button that allows the users to export data from a form to the directory and file of their choice.

This code works when we're just running Access, but we need it to function in runtime, and it just crashes with an entirely uninformative "runtime error" message.

I didn't write this code, but looking at it, it seems to be just a copy of what's in the MS knowledge base about the filedialog function.

I also never write my own applications using runtime (the program we're running this is was contracted for our lab), so I have no idea why this would be failing in runtime but not in Access. Can anyone help?

View 1 Replies View Related

Modules & VBA :: Build Event - Access Crashing

Jul 9, 2014

I am trying to build an event when I double click a field. As soon as I click on Code Builder, access crashes. It does this with every access database I open.

View 14 Replies View Related

General :: Module Crashing After Changing Window Mode In Macro

Sep 10, 2014

We have been calling a main form to manage yacht races using a hyperlink/macro from a selection form which lists all the yacht races ..The main form was too big to fit on some screens so we changed it to pop up mode to allow it to be resized and use scroll bars. this works well when the form is opened manually and all functions run just fine

the hyperlinik/macro for race selection had originally been set up to call the main form in dialog mode but we have had to change this as it disabled the resizing of the form and the scroll bars..The macro tool doesn't offer pop up mode so i selected window mode = normal and the main form opens with a resizable window and scroll bars but all the functions called from this module now fail (error message = use of null value or similar and all the functions go into debug mode - the server is down and i can't access the system to get the exact details)

If i change the macro in the selection form back to window mode = dialog the functions work but i lose the resizing of the main form and and the scroll bars.

View 1 Replies View Related

Calculated Field In Access Query Contributes To Crashing Excel Table Upon Import

Oct 24, 2012

I have a simple calculated field (As "Ratio") that is readable in Access 2010 query, but crashes in Excel upon importing/running the query in an .xlsx table.

ERROR MESSAGE in EXCEL: "The query did not run, or the database table could not be opened...check database server..contact your database administrator.."

I am simply taking the cost amounts of each project record (shown as "Record Cost") and dividing it by the "Total Cost" of that project to render "Ratio".

The Total Cost is retrieved from another table.

Testing scenarios:
If we exclude Ratio, the whole query import just fine.
If we filter the query to one project (i.e. "Project A") the ratio field imports fine.

However, the whole unfiltered query does not with the ratio!

Other testing scenarios:

If we use a constant for the denominator AS "1" in Ratio (i.e. recordcost/1) the whole unfiltered query and ratio field imports fine.

If we use a constant for the numerator AS "1" in Ratio (i.e. 1/totalcost) the whole unfiltered query upon import crashes in Excel.

This is a mock example of the dataset, the actual query has 50K+ records:

Project Service Date Record Cost Total Cost Ratio
A Welding 1/1/2012 $100 $120 83%
A Plumbing 2/1/2012 $20 $120 17%
B Welding 1/1/2012 $50 $75 67%
B Plumbing 2/1/2012 $25 $75 33%
C Welding 1/1/2012 $40 $61 66%
C Plumbing 2/1/2012 $21 $61 34%

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved