Access Crashes When I Open A Second Database

Jun 8, 2007

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.

View Replies


ADVERTISEMENT

Access Crashes When Try To Open A Macro In Design View

Oct 21, 2015

Without 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.

View 5 Replies View Related

Database Crashes

Nov 10, 2006

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 Related

Database Crashes When Compacting

Aug 29, 2007

At 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

View 1 Replies View Related

Query Crashes Database

Mar 19, 2007

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:

View 3 Replies View Related

Database Crashes After Table Update

Sep 8, 2011

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 Related

Access Crashes, HELP!

Aug 4, 2006

Hi

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

View 5 Replies View Related

Access Crashes

Aug 9, 2006

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!

View 14 Replies View Related

Access Crashes

Nov 28, 2006

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 Related

Access Crashes, HELP!

Aug 4, 2006

Hi

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

View 2 Replies View Related

Access Crashes On Export

Aug 9, 2007

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

View 6 Replies View Related

Access Crashes After Query

Jun 9, 2005

Hi,

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

View 1 Replies View Related

Access Wizard Crashes App

Feb 2, 2005

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.

View 5 Replies View Related

Access Crashes Exporting To Dbf

Jan 31, 2008

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.

View 10 Replies View Related

Access Crashes Connecting To Odbc

Aug 16, 2006

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??

View 1 Replies View Related

Modules & VBA :: Access Crashes When Connecting To DSN

Apr 20, 2015

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?

View 1 Replies View Related

Access Errors And Crashes On New System

Jul 24, 2012

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.

View 7 Replies View Related

Queries :: Access 2013 Crashes When Printing Reports?

Dec 9, 2013

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 Related

Reports :: Changing Image In Control Crashes Access

Sep 16, 2014

On 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 Related

Crashes While Adding Data Into Access Memo Fields

Jan 7, 2013

We 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 Related

Cannot Open Access Database...

Nov 3, 2005

Hello. I haven't seen this before with Access; I've searched the forum and haven't found anything yet...

I have an Access database that was being used by about 9 different people. Everything was going along okay, but one day it became read-only for no reason. Once everyone got out of the DB it said it needed repairing. So with only one person in I ran the repair, but the horror-inducing message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." appears and when I click "OK" on the message nothing happens whatsoever.

Luckily backups existed, but some data was lost. Is there anyway to run a repair on the database that won't open? Or is it a lost cause?

Thank you! :D

View 3 Replies View Related

Access 97 Database Won't Open

Jan 3, 2006

We've got a client that runs two access 97 based databases on their network. up until recently both databases worked

fine on all workstations (all XP Pro).

About 3 weeks ago they called me to report that one of the databases would not load on 3 workstations. It opened

fine on all the others. I checked out the permissions on the database (which is stored centrally on the server) and

everyone had full control.

Within the last week they have added two new xp pro workstations to the domain - neither of which can access the

database in question. they can access the other database no problem - as can all the other workstations.


The occurs as follows:

1. Double click on the icon for the database

2. access 97 loads but does not load the database's interface - instead it opens an empty version of access (with

file menu etc at the top)

3. no specific error messages at all.

4. close access and the standard xp program crash message appears (see screenshots below)



As mentioned above, other workstations can open the database fine.

the only thing that has changed on the network is the installation of some server and workstation based production

software - we have not yet consulted with the company that installed this - we felt that if it was this software

causing the problem then all workstations would be suffering. we wil have to consult with them once we've exhausted

all the possibilities.


Thanks in advance for any advice

http://www.techresource.co.uk/error1.jpg

http://www.techresource.co.uk/error2.jpg

View 5 Replies View Related

Access Database Does Not Open

Jul 13, 2007

I have a user who is having trouble opening a database he created. Here is his description.
I am having an issue with Access that has occurred today and once several weeks ago.

First, I build a complex database for Safeway report. It functions correctly, I can access it from excel.

Problem, I go to update or modify the databases, Access gives me the macro message which I override.

The access database window will not open, no error appears, just a blank access screen with tool bars above.
I have tempted to do a compact and repair of the database which did not help.

Microsoft Online help says the issue can be cause by old Anti Virus Software.

The database will permit excel to pull data from it.
Does anybody have an answer.

View 1 Replies View Related

Can't Open Database In Access. Please Help!!

Dec 29, 2004

I've inherited a database and I need to export the data to a new program. I can access the DB through a front-end program, but it doesn’t give an option to export the data. I have a username/password for the program, but I can’t open the DB in access. I can't even get to the point of entering a password. The program is 8 years old and the company has been acquired by another company. I tried contacting the new company and they’ve never heard of the version that I have. I’ve even tried contacting a supervisor.


On opening the db immediately gives the error:


“You do not have the necessary permissions to use the ‘C:.....mdb’ object. Have your system administrator or the person who created this object establish the appropriate permissions for you.”


I’ve tried the following with no luck:

1. Create a shortcut to use an alternate mdw file. "C:XXXMSACCESS.EXE" "C:XXXdata.mdb" /WRKGRP "C:XXXSystem.mdw"
2. Holding down the shift key while opening the file
3. Compact and repair
4. Converting it to prior version
5. Creating a new database and importing all objects


Is there a way to "read" the db file to see if there is a valid user name?


I found the following suggestion, but have no idea how to do it:

http://www.vba-programmer.com/Access_Code/List_Groups_Users.txt and this
http://www.vba-programmer.com/Access_Code/Security_Listing_Permissions.txt
and try the .mdw files again, using the users(and/or groups) that have permission

If it's still not working?, there might be a way to jerry these
http://www.vba-programmer.com/Access_Code/Security_User_to_Group.txt
http://www.vba-programmer.com/Access_Code/Security_Group_Account.txt
http://www.vba-programmer.com/Access_Code/Security_User_Account.txt


I'm not a programmer so if anyone has any easy solutions (or even better a sample!) I’d greatly appreciate the help!

Thanks in advance!!

Joe

View 3 Replies View Related

Cannot Open Access Database On Network

Oct 24, 2007

We have 11 computers on the network. One has an Access back end file. When we try to open this file via the network some of the computers can open it others get the follwing message.

"Microsoft Access cannot open this File

This file is located outside your intranet or
on an untrusted site. Microsoft Access will not
open the file due to potential security problems.

To open the file copy it to your machine or an
accessible network location."


Do not understand why all the coputers cannot open the same access database file. Please Help Regards Keith

View 12 Replies View Related

Sharing Access Database So That ASP Can Open It

Apr 8, 2008

I have an access database which is shared, I can open it on 2 pcs at the same time no problem. I also have an html and asp page which is used to add recoreds to the database, this works fine if the database is closed everywhere else but this cannot be the case. I am now desperate for answer to any help would be greatly appreciated.
I have attached the asp file, I can upload all files and database to a server if someone requires them (too big for the forum).

Thanks,

Richard

View 2 Replies View Related







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