473,657 Members | 2,430 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2003 keeps crashing

6 New Member
I've been tearing my hair out on this one. This effin' database keeps crashing on me while I'm doing query-related operations.

System info:
Access 2003 SP2 with all the latest updates on an XP Pro machine.

DB info:
The database file in question is merely several queries based upon a single, linked Excel file of about 17,000 records that resides in the same directory as the Access file, both of which are stored locally on my machine.

Problem:
It started when I was simply right-clicking on a field in the query's design view and selecting "build." It would hesitate for a moment, then it would crash and offer the option to "Repair and re-open" the database and send an error report or not. I tried opening the database file in Access 2K on my home machine and the problem would not occur in that environment.

I'm now trying to run a very simple Union query and I'm experiencing the same problem. Here's the meat and potatoes from the error report:

Expand|Select|Wrap|Line Numbers
  1. AppName: msaccess.exe      AppVer: 11.0.6566.0     AppStamp:42cdb33e
  2. ModName: msjtes40.dll      ModVer: 4.0.8618.0      ModStamp:403430ac
  3. fDebug: 0       Offset: 000092d0
Attempted solutions: (none of these have had any effect)
Did a repair of Office/Access
Uninstalled and re-installed Access
Uninstalled and re-installed Office
Performed a compact/repair on the database file.

Thanks in advance for any help on this one.
May 31 '06 #1
1 3693
PEB
1,418 Recognized Expert Top Contributor
Hi,

Try to transfer your information from Excel to Access and then try your queries!

Do it only to try if it works!

Than you'll think how to do your facilties to migrate your data and so on...
Sep 9 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
7379
by: nobody | last post by:
Hi: I am using Visual Studio .NET 2003 and console project (disabled precompiled header). I am using _tcstok() which resolves to strtok in my case. It keeps crashing (unhandled error, access violation). Firt I thought my variable wasn't writtable (const) but it wasn't so I used literal as input but it still crashes.
2
1987
by: Lee Grissom | last post by:
Find in Files in my VS.NET 2003 IDE has suddenly stopped working. It stopped working after I did a global solution Replace in all files operation. I shut down the IDE twice, but it still doesn't work anymore. See the example output message below. For example, I searched for "class", and it doesn't even fine that. :-( <quote> Find all "class", Match case, Whole word, Subfolders, Find Results 1, Entire Solution, "*.*" No files were...
14
5259
by: JK Peck | last post by:
I have a fairly large Access application that ran correctly in Access 2000. After upgrading to Access 2003 (and recompiling and updating references), it reliably crashes at a certain point. If I step through the VBA code, the crash does not occur. What is different about stepping through code instead of just running it? Any idea how to find the cause? I know about where it happens, but since it is Access itself crashing, finding a...
1
2251
by: russ | last post by:
Hi I need some advice about ms-access limitations. i have some databases written by others i have been working with that keeps crashing. different on different computers, so it sounds like a memory thing. i have some tables which are deveral hundred thousand records long and a few tens of records wide. will this cause a problem? is there a total max no records or database/file size? any links to websites discussing this would be...
47
4514
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
4
1829
by: Piedro | last post by:
Hi group I'm trying to run the msde setup from my program with the following piece of code and the msde setup just keeps crashing after it has run for a couple of seconds. If I try to run the setup from start/run and then enter c:\msde\software\MSDESetup\setup /settings c:\msde\software\MSDESetup\setup.ini it works just fine but if I call it from my prog it crashes, if tried a lot of things to solve it. I've already placed the command in a...
1
3284
by: someone | last post by:
Hi all, I have installed Visual Studio 2005 on Windows XP. Visual Studio keeps crashing every 10-15 minutes. Can you please tell me what can cause this poblem and how to fix it? Thanks.
3
3963
by: hbean | last post by:
I'm working on an event procedure for a form - seems relatively straightforward to me, but for some reason Access keeps crashing on me. All the procedure is doing is checking to see if a recordset is blank, and if not, opening up a form. Any ideas why this might be happening? Here's the code I'm using: Dim db As Database Dim Active As Recordset
8
13242
by: mark_aok | last post by:
Hi all, I have a split database. Both the forms, and the tables are stored on a shared network drive (this is Access 2003). The users use the forms, and the tables on the network drive, there are no local copies. When connection to this drive is lost, Access CRASHES. It does it every single time. Does anyone know if there is a way to check if
0
8305
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8823
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8503
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8603
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6163
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4151
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
1944
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1604
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.