Access queries do not run

[David B.]

Problems with access query action.

I have been beta testing Office2003 and had it installed
in it's own partion. I began to do a uninstall just to
clean up the databases alittle and once done my Office 97
Access would not run it's query portion of the database.
Every once in awhile I will recieve macro message asking
me if I want to enable or disable the macro. I am
begining to think that maybe I unleashed a Macro virus. I
read that there are old MDAC files that were over written
in the registry by 2003. I tried to do a uninstall but to
no evail, it did not work. I even went as far as
installing ODBC. drivers from the value pack to over
write the old and they did not help the situation. not to
mention that I installed Office2003 again and now it's
qurey does not work as well tried the detect and repair
database and it did not work.

 

[[MVP] S. Clark]

Rule #1: Don't install a beta anything on a working machine. Use another
partition, VM Ware or a completely seperate machine.

You can continue to chase it, or you can wipe the machine and start over.
I'd go with the latter, as it is guaranteed to solve the problem, and it can
be completed in just a couple of hours.

$0.02

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-