Hi all, please help.
I have created a append query, which runs fine.
But unfornately whenever I try to open this query in design view it crashes the whole Access Database.
This is extremly frustrating as I cannot amend this query, or even check it to remember how it works.
:eek:
I cant see a single question on these forums which, relates to this problem.
Please help if u can!
:confused:
I have an Access 2003 database on a server at work. The server's operating system is NT4 SP 6A. We typically have about 5 to 7 people at one time accessing the database. Records are not locked. We recently hired a temp to enter information into the database. The database crashed and has been crashing ever since. It has become a big hassle because a couple other databases use this database as well for information. The database was developed on a XP system. The computers that crashed are running Windows 2000 Version 5.0 Build 2195 SP3. The database files size is under 5Megs. Any suggestions on where to start? Also, I thought I came across some piece of information that said the max. database size is 3Gigs. Is this true? Steve
View 2 Replies View RelatedAt work we have a database that is about 60mb and whenever we try to compact and repair it access crashes. Anyone know why it does this or whether it even matters?Thank you!
tim
If I already have an Access database open (sometimes I've forgotten about it), when I try to open another one from my desktop, it maximizes the first Access window, and then my computer freezes--I have to CTRL-ALT-DEL and close both of them through Task Manager to continue.
I have never seen this happen on anyone else's computer. Does anyone know what is causing the problem? It is not any one database; the problem occurs no matter which are opened.
Thanks in advance.
My 886 Mb access database crashes at any time I use the form I use to navigate it as the main menu. This just happened after I updated one of the tables.However, I've had this issue of not being able to compact and repair this database for a long time. This database is on one of our network drives. I tried to copy to my hard drive and it also hang up!
View 3 Replies View RelatedHi,
I've run into a big problem recently. Whenever users run a specific query they receive an error that says, ACCESS has encountered error and will be shut down. the exact error message is shown below:
Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
the Error Signature is the following:
AppName: msaccess.exe AppVer: 10.0.2627.1 ModName: msjtes40.dll
ModVer: 4.0.8618.0 Offset: 00009065
what is going on here? I'm not sure why it does this, it used to work fine. Any ideas would be greatly appreciated.
thanks
I have a table of events, tblActivitiesDates which have an activity type and a date.I have a form which has a datasheet with a query source (a separate datasheet form embedded in this one), and 2 radio buttons. The query that is used uses radio buttons this way:
-Activity Type Filter: A radio button, that when clicked a combo box appears, with a list of activity types to choose from. Basically, filtering by Activity Type.
-Date Type Filter: A radio button, that when clicked 2 text boxes appear, in which you write the dates between which you want to see the events organized in the table. Basically filtering by dates.
To make reading easier, Activity Type Filter=ATF, Data Type Filter=DTF.There are 4 possible options:
-ATF=ON and DTF=ON
-ATF=ON and DTF=OFF
-ATF=OFF and DTF=ON
-ATF=OFF and DTF=OFF.
For each option, I have written a line of code in the appropriate OnChange/AfterUpdate/Whatnot events in the form: CurrentDb. QueryDef ("qry ActivitiesDates"). SQL = "SELECT..."according to whatever option is currently active.
When I enter values into the form, and instead of embedding my datasheet form I simply open it every time from the navigation pane in a new window, the datasheet is filled appropriately and works 100%. Of course, I have to reopen it every time I change something so the query will rerun.After the table crashes (will be explained soon), I re-embed it to the form before trying it again. The first time I re-embed, no matter what I do, the query doesn't update nor crash.
Say I start with the option ATF=ON, DTF=OFF, it will work fine, updating when needed, but if I tick DTF=ON, regardless of the dates I enter, the table will only change according to the first option (While when open in a new window will show the correct table entries), ignoring the fact that the QueryDef. Sql has changed. Once I tick ATF=OFF, the table crashes and I get the error:"Run-time error'3420': Object invalid or no longer set".The exact same thing happens when I go DTF=ON,ATF=OFF. It ignores the event types I enter, and once I tick DTF=OFF, it crashes with the exact same error.
I added Me.Activities_DS.Form.Requery (datasheet's name is Activities_DS) in every place it should update.
I have DB in access 2007. I have a report that is uses a select query to generate the information for the report. It has been working great, But however lately like maybe with in the last month, it has been causeing Access 2007 to crash. I am having the same issue with another DB that uses the same information but that information is imported in. both Databases have worked great up until two months ago. Microsoft states that it is because of the program. I have tried to repair the DB by using the Repair option. I am confused as to why this would be happening. I can create a new report and it seems to work. but I do not want to change all the DB on everyone's computer just for this reason. I also have two buttons on my report that utilize macros to close or print the report.
View 6 Replies View RelatedHi
On certain machines when the user clicks a button the click command performs an openreport event procedure in print preview. Access then crashes saying it encountered errors and will close. When I change the click command to open the report by a moacro the report opens fine.
I've already installed SP3 but no difference.
Any suggestions please!!?
Dave
Problem: Access crashes during data input in a certain form. – Not always on the same field, and not always on the first record. Sometimes I can input 2 or 3 records and it crashes on the 4th. The "modul" that the crash shows is always the msjtes40.dll
Action taken so far:
1.Checked the version of the msjtes40.dll – it’s the latest
2.reregistered the msjtes40.dll
3.Created a new DB imported everything
4.Repaired the Db
5.decompiled and compiled all the code (which I have been through with a fine comb - there is no complidated VBA on the form at all.)
6.recreated the form entirely
7.Checked the Source of the form for any funny records
8.reinstalled the entire Office XP Professional
I really don’t know what else I can do!
Hello.Your help is very much appreciated.I am using ACCESS 2002 (XP).I have two access files - one program (with link tables) and the other one is the database.I created ACCESS report.When opening the report for viewing - it's all good.(DoCmd.OpenReport "_rptDetails", acViewPreview)When trying to save the report to a file - Access saves it to a file and immidiately crashes.(stDocName = "_rptDetails"DoCmd.OutputTo acReport, stDocName)when printing - it prints and crashes(stDocName = "_rptDetails"DoCmd.OpenReport stDocName, acNormal)I tried:1. To make the data source of the report a table instead of a query.2. Complied the code again.3. Copied everything into a new database.4. Created a new report from scratch.Nothing helps.Would you have any idea of what causing the problem?Thank youRoy
View 6 Replies View RelatedHi
On certain machines when the user clicks a button the click command performs an openreport event procedure in print preview. Access then crashes saying it encountered errors and will close. When I change the click command to open the report by a moacro the report opens fine.
I've already installed SP3 but no difference.
Any suggestions please!!?
Dave
Hi all,
Forgive me if this is in the wrong forum.
I have a colleague who has a problem where Access 2003 crashes every time they try to export a table to Excel 2003. It doesn't matter what mdb is used Access crashes.
Any help?
Thanks,
RL
I have been having this issue with two different
versions of Access, firstly XP and now 2003.
The issue is every time I open a blank database, and
click on the "create using wizard" option, access crashes
while trying to set up the wizard. When I view the
dump rep, it all seems to point to msaccess.exe.
AppName: msaccess.exe AppVer: 11.0.5614.0 AppStamp:3f3c8e3c
ModName: msaccess.exe ModVer: 11.0.5614.0 ModStamp:3f3c8e3c
fDebug: 0 Offset: 000ef3ba
I have uninstalled and re-installed Office onto
different drives etc, but still no joy.
Does anyone have any ideas?
Thanks
Richard.
I am trying to export a table out of Access to a dbf. However, when I do this Access crashes and shuts down. I am able to export the table to any other format also I am able to export the table to dbf from another computer. My setup is XP Pro SP 2 with Office 2003 SP 3. I just moved from SP 2 to SP 3 hoping that would solve my problem, but it did not. I have tried uninstalling and reinstalling office, detect and repair and a different user profile.
Any suggestion would be great. Thank you in advance.
I've just set up my Access on a new PC and now when I try to connect to my MySQL database through odbc, Access crashes without any error messages, just the standard microsoft error reporting message.
I'm using Office 2003. What do I do??
I am connecting Access to QuickBooks with the QODBC. I tried to do this in MS Access 2010 with Windows 7 and it worked fine. Then I tried it on a new computer with MS Access 2013 and Windows 7. Now, when the VBA gets to the line:
oConnection .Open "DSN=Quickbooks Data;OLE DB Services=-2"
It crashes. No message, other than the generic "Access has stopped working" message. I am using ADO for the oConnection. I am not sure what the problem is or how to diagnose it. I have used an ADO connection to connect to Excel, and that worked fine, so my guess is it have something to do with the DSN connection?
My office computer, along with the phone system, printers etc took a lightening strike last week. The hard drive survived but not the computer. I was able to get the office access db onto a new system but now I get errors when running it. When opened, the main menu appears. Whoopee!Not so fast. When I select an item, I get "the expression On Click you entered as the event property setting produced the following Automation error. The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]There may have been an error evaluating the function, event, or macro"
Pressing the button a second time does not produce the error and opens the correct form.This form works properly. The second problem is with a second report form that opens properly.This form expects dates and accepts them but when I try to print the report, access closes with no error message.
I have a form I use to create photo captions. The form has a field where users can edit a pre-generated caption and a field that stores their updates as a final caption in the field "selected_caption".. On my form is a button that runs the code below to check and see if a field ("updated") has been marked true, then copies the content of caption field into the selected_caption field. It works fine 90 percent of the time but for some reason this caption:
LA 109535, LA109535 partial site overview showing blowout with PL's 01- 04. Crew person is excavating a shovel test probe. Photo direction facing southwest. (Roll 31066, Frame 4958)
Results in a missing operator error. I thought it was like a special character thing, so I removed the "'" and the "-". Same error.
Code:
Dim db As Database
Dim rst As Recordset
Dim upcap As String
Dim strSQL As String
Set db = CurrentDb
[Code] .....
When I try to run compact and repair on any database that is ~500MB or larger, Access crashes . It is pretty consistent on when it crashes.. e.g. a DB that is 692MB crashes when the temp DB reaches 569MB.
Here is where it gets stranger. .problem happens on multiple databases and I can copy the DB to another computer with Access 2007 (Same version) and Compact/Repair works fine.
For problem / attempted corrections I have tried the following with no luck
Checkdsk - OKBoot in Save Mode - Compact / Repair still crashesMove DB to another HD on my computer (Thinking I may have disk failing) - Compact / Repair still crashesUninstall / Install Access - - Compact / Repair still crashes
We have run into a problem with Access 2013 when trying to print reports. The program always crashes. Have updated printer driver for the HP LaserJet P2035.
View 1 Replies View RelatedOn open I change the Picture property of an image control to another image. I do it 2 places. Access crashes on the first change or on the second. In about 50 % of the cases.
View 4 Replies View RelatedWe are running many MS Access databases in a mixed estate - mostly Windows XP terminals. The databases are split with the front end on the desk top and the back ends on a server running Windows Server 2003. We have a chronic problem of crashes when users go back into memo fields to add data - all text. The problem is intermittent, not possible to reproduce and varies in frequency.
View 2 Replies View RelatedWithout having made any changes to my setup, Access now crashes when I try to open a Macro in design view. I have checked the Trust Center and the folder where my database is stored is trusted (including sub-folders).
I am running Office Pro 2013 with Windows 8.1.
I am sending an email using SendObject. Sometimes it works, and sometimes it makes the computer freeze up with no error message. I have tried this with Outlook running or not running, seems to make no difference.
Code:
'The sub procedure below sends e-mail in response to a click on the Send button.
Private Sub SendMessagesButton_Click()
'For Access, define some object variables and make connections.
Dim myConnection As ADODB.Connection
Set myConnection = CurrentProject.Connection
Dim myRecordSet As New ADODB.Recordset
myRecordSet.ActiveConnection = myConnection
[Code] ....
I have added some MsgBox () to narrow down where it crashes. It is after 'Five' and Before 'Six'. On the line:
Set appOutlookRecip = .Recipients.Add(eMailAddress)
I am mystified as to why it works OK sometimes, and not others. The email address being used is valid.
On trying to import an Excel 2007 file into Access 2007 I get the following:
1) Choose "External Data," Import, Exce
2) Select small file in MS Excel 2007 format.
3) Click on Import the source data into a new table ...
4) Choose OK
Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.
Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.
Event Viewer gives following message, which is of no help:
"ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."
Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.
I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.
I have turned off DEP.
How can I get MS Access 2007 to import Excel?
Thanks
Ken