Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / April 2008

Tip: Looking for answers? Try searching our database.

Cross-Post: Database crashes only on laptop

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NickX - 29 Apr 2008 15:09 GMT
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
George Nicholson - 29 Apr 2008 17:42 GMT
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

Signature

HTH,
George

> hi all,
> I have a laptop with an access database (front-end / back-end setup)
[quoted text clipped - 24 lines]
> Thanks,
> Nick
NickX - 29 Apr 2008 19:31 GMT
Thanks, George
I'm checking that now
Nick
NickX - 30 Apr 2008 14:29 GMT
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
George Nicholson - 30 Apr 2008 22:43 GMT
It works for you, but not for others *on the same machine*?

Signature

HTH,
George

> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.