By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Access 2003 keeps crashing

P: 6
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
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
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

Post your reply

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