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

Microsoft Access 97 crashes everytime I try to run VBA code on Windows Vista

P: 2
Title says it all: Microsoft Access 97 crashes everytime I try to run VBA code on Windows Vista.

It was working fine yesterday.

This has happened to another machine in my workplace running Windows 7.

The crash is silent, there is no warnings.

The actual application EXE process is still running, the front end dissapears and the code is not run at all.

Compacting/Repairing the DB didn't help.

Running as an Administrator or compatibility mode doesn't help.

Any suggestions?
May 21 '14 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 5K+
P: 5,397
close everything out and shut down.
COLD Boot... do not restart... shut off the power, wait 60sec and power on.

Updates can cause this issue.

Welcome to running very very old software on newer OS, there will be occational weirdness to contend with.

Run a full virus/malware scan on your entire network.
We cannot help you here with virus removal; however, any search engine will turn up numerous forums where there are people of good heart willing to help too! (^_^)

If possible you should consider moving everything to Office2010 or newer. There are a lot of changes so visit the MS website to review these alterations.
May 21 '14 #2

P: 2
We're trying to migrate to a newer Access, but corporate policies... we ran malware removel on several machines, but nothing. The same thing is happening in several other machines across our network.
May 22 '14 #3

Expert Mod 5K+
P: 5,397
Can you fiew the system-application-error logs?
(( <window key><R> eventvwr.msc <enter> ))
(( check for application error messages ))

- Check with your IT, did they force any system updates?
- You have tried this with all of your access database files?
- What size is the datafile?
- Can you create a new simple database, 1 table, 2 fields, simple select query?
- Can you create a new database as above with a form?
- Can you open a new database and import the tables from the old database?
May 22 '14 #4

Post your reply

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