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.
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 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
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
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!
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.
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
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
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.
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.
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.
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.
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 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.
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.
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.
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.
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?
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.
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!
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
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).
