Cross-Post: Database crashes only on laptop

N

NickX

hi all,
I have a laptop with an access database (front-end / back-end setup)
that functions properly until you try to search using the combo box.
As
soon as you hit Tab or Enter it says "Microsoft Access has encountered
a
problem and needs to close..." I have the same db on my development
machine
and can not duplicate the error. The error occurs whether the laptop
db is
in .mdb or .mde format. The only difference that I can see between
the two
is listed below (VBA versions):

Both Machines:
Windows XP Professional v5.1.2600 SP2 Build 2600
Microsoft Access 2002 (10.6771.6839) SP3

Desktop Only (Dell Optiplex GX620):
Microsoft Visual Basic 6.5 v1024 VBA: Retail 6.5.1024 Forms3:
12.0.6211.100

Laptop Only (Panasonic CF-18):
Microsoft Visual Basic 6.3 v1024 VBA: Retail 6.5.1024 Forms3:
11.0.5709

Thanks,
Nick
 
G

George Nicholson

Since you say both have Office 2003 SP3, I'm going to assume that isn't the
problem here, otherwise that would be my first reaction.

Just a wild guess, but do you have Office 2007 Compatibility Pack installed
on your Desktop but not the Laptop? (Forms 12 versus 11 makes me suspect
that possibility.)

I've had issues with the O2007 Compatibility pack automatically "updating"
library references (MSO.dll, Office library versions 12 & 11 specifically)
so that when a working mdb is copyed from a machine with O2007Compatibilty
to a machine without, it fails to work (with errors similar to yours) when
it stumbles over the reference to a "future" version.

Solutions: uninstall O2007Compatibility on source/development machine and
recompile, copy, distribute
or
make sure all recipients have O2007Compatibility installed
 
N

NickX

OK,
This is strange. When I log in to the laptop and use the combo box
search it operates fine. But when other users log in the search blows
up and crashes access. Any ideas?
Thanks,
Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database crashes only on laptop 2
Updating Access 2003 Visual Basic engine..... 1
RecordSet Type mismatch using Access 2007 VB script in Access 2002 2
Excel VBA Paste of Range with PrefixCharacter fails from VB.NET 1
Database crashes on entry into API Macro or Visual Basic in WindowsXP but not in Windows 7 1
Problem interacting between VB.NET and VBA6 with Excel 2003 2
Converting Access 2000 database to Access 2007 2
Error 0x80040E4D when tryng to open an password protected Access database programmatically 1

Top