asked on

"No valid fields can be found..."

Hello,
Recently i have encountered strange problem on one computer: sample DB, when trying to run Form Wizard, there are none fields listed at "available fields". The same DB (.mdb) at another computer is just fine - all created fields are available. Have tried different users (including administrator) - same results. Also, the same problem is with all .mdb files on that computer.

WinXP SP2 + hotfixes
Office 2000 SP3 + hotfixes

Any ideas, where problem can be? I suspect ODBC. MS Office was reinstalled - the same results.

peter57r

Hi tapkep,
What is the source of the tables? SQLServer database or what?

Pete

tapkep

ASKER

.mdb file
There are no server installed, just MS Access.

The same .mdb file copied to another computer has it's fields accessible.

ASKER CERTIFIED SOLUTION

Hamed Nasr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tapkep

ASKER

hnasr, i have tried opening northwind.mdb (from MS Access samples). "Available fields" in Form Wizard is empty. Also, i removed and installed MS Office 2000 - same results.
Anything else to try before reinstalling PC? :)

tapkep

ASKER

Found problem - antivirus (Kaspersky Business Optimal) was blocking VBA scripts.

Hamed Nasr

Interesting! Try to set the antivirus properties to warn you, not just block other programs!

tapkep

ASKER

Interesting, indeed. The same antivirus, another computer - no problem at all. Will try to compare setups (but at the first glance they look the same).

Hamed Nasr

Try to compare, on both computers, the References from Tools in Visual Basic and post here any findings!

&quot;No valid fields can be found...&quot;

"No valid fields can be found..."