Access 2010 SP1 VBA errors

#11

On Dec 1, 4:42*am, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:

Quote:

On 30/11/2011 15:11:22, Patrick Finucane wrote:

On Nov 30, 12:24*am, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:
Me, XP/32 bit.

As near as I can tell Access 2010 is extremely unstable. *Decompile
sometimes works, sometimes doesn't. *It constantly crashes when
opening anything dealing with VBA * *Perhaps it's MS's subtle way of
moving developers from VBA into macros.

Access 2010 is a pretty program. *As one manager said to me many years
ago "I prefer an ugly program that works to a pretty program that
doesn't."

For those of you unfamiliar with the A2010 feature...one designs some
tables and forms with some code and some modules. *Works like a
champ. *Quit the app. *Re-open it. *Attempt to open a code module o
r a
form in design mode. *That generates a MS generated "Gee, we are sorry
but we need to close this corrupted app." msgbox.

I think we are stuck with an inferior product, Phil.

FYI, I've been using 2010 for about 9 months as my primary version - both
with new accdbs, old mdbs, and mdbs that were converted to accdbs. I have
not had a corrupted database once. Not once. So perhaps it's somethingwi
th
your install? Maybe uninstall and reinstall? For me, 2010 is working like
a
charm, and I'm loving using it.

I will say, though, that it has a problem with 2007 databases. Once you
modify it in 2010, you can't use it again 2007, even if you don't apply a
ny
of the 2010-only features. But that problem is common knowledge.

Anyway, I'm running XP and 32 bit Access 2010. FYI.

Neil

Hi Neil. *Knock on wood. *It's an issue MS is aware of. *I like A2010
tho I preferred the ribbon in A2007. *I'm sure my issue of corruption
is due to some conflict with some hardware or software or security
feature which I have no control over at work. *It's simply annoying to
work on a mdb, close it, reopen it, and have it corrupted.

What had me scratching my head was the running a Decompile from a
desktop icon and failing but following a MS's solution to run the
Decompile from DOS which works. *I am unsure why the decompile works
from DOS but not from Windows.-

I use a little batch file

Copy "C:\Phil Data\Access\MDB 2010\Clubs 2012.accdb", "C:\Phil
Data\Access\MDB 2010\Decompile Clubs 2012.accdb"
"C:\Program Files (X86)\Microsoft Office\Office14\MSACCESS.EXE" "C:\Phil
Data\Access\MDB 2010\Decompile Clubs 2012.accdb" /decompile

This creates a new database "Decompile Clubs 2012.accdb"
I then rename the original database and include the date, and rename
Decompile Clubs 2012.accdbDecompile Clubs 2012.accdb back to the original
name of "Clubs 2012.accdb"

Spoke - yes actually spoke to a Microsoft professional about the problem,and
there is a hotfix

Seehttp://support.microsoft.com/kb/2596585
Apparently if you are using 64 bit windows, the automatic fix thinks you will
be using 64 bit Office, and I guess most of us are using 32 bit Office

If you installed the x32-bit version of Office, select the “x86” Platform
version of the fix. (office2010kb2596585fullfilex86glb)

If you installed the x64-bit version of Office, select the “x64” Platform
version of the fix. (office2010kb2596585fullfilex64glb)

Seemed to work for me, but no guarantees

Phil

Phil's link to the hotfix seemed to do the job.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access 2010 SP1 VBA errors

comp.databases.ms-access comp.databases.ms-access

Re: Access 2010 SP1 VBA errors - 12-10-2011 , 01:45 PM