Strange access crash on Acer machines

[Movian]

Ok so we have 2 acer machines that we are having nothing but problems with.

To start with acer included some word plugins that were preventing our VBA code from correctly using the saveas functionality in office automation. Once those were disabled we thought everything would be fine....


however they have aparently another issue, when opening a form and setting a listbox row source the acer machines are having a full access crash to desktop. Our built in error trapping in the sub is not being triggered so it looks like its access itself that is crashing...

none of their non Acer machines have this problem nor do any of our other clients machines.


the line of code that I tracked the crash too (using msgboxes ) is


Forms("frmDXPickList").lstDX.RowSource = "SELECT DX FROM DXList WHERE CPT = '" & CStr(Me.Service) & "';"

I tried recreating the form manual (without copying any controls over) in case the form was corrupted but it still has a hard access crash...


I uninstalled from programs and settings the Acer bloatware that looked related to office but this didn't help either....

does anyone have any other ideas on where to look ?

as always thanks in advance ^_^

[ranman256]

This SOMETIMES works....I've had the same program crash on certain PCs so try this on the troubled PC...
Make a new blank database.
Import EVERYTHING from the app...all tabls, qrys, macros, etc.

It doesnt always work, but sometimes it does.

[Movian]

This would help resolve the issue if its due to corruption (something access databases seem to be overly prone to).

However this has already been tried and did not resolve the issue.

Fairly sure that one of the other pieces of Acer bloatware has done something to office just like their word plugin screwed up the saveas functionality for office automation

[ranman256]

Dang! Hate those. I had one that never went away.
Did you look thru the VBA,tools, REFERENCES and remove everything except whats needed?

[Movian]

Yeah We keep the references pretty tight.

Micsofot Scripting Run Time
Microsoft Internet Controls
Microsoft Active X Data Objects 2.5 Library
Microsoft DAO 3.6 Object Library


Those are the only additional references and all are needed.

Some clients use a custom reference we created for cryptographic functions but this client doesn't have or need those.