"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.
LVL 6
tapkepAsked:
Who is Participating?
 
hnasrCommented:
1-Create a blank database on the current computer.  Create a small table and create a form.
2-If small database works, suspect the other database and try to compact the other database on the current computer. and try.
3-If small database doesn’t  works, then suspect your installed software on the current computer.
0
 
peter57rCommented:
Hi tapkep,
What is the source of the tables? SQLServer database or what?

Pete
0
 
tapkepAuthor Commented:
.mdb file
There are no server installed, just MS Access.

The same .mdb file copied to another computer has it's fields accessible.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
tapkepAuthor Commented:
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? :)
0
 
tapkepAuthor Commented:
Found problem - antivirus (Kaspersky Business Optimal) was blocking VBA scripts.
0
 
hnasrCommented:
Interesting! Try to set the antivirus properties to warn you, not just block other programs!
0
 
tapkepAuthor Commented:
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).
0
 
hnasrCommented:
Try to compare, on both computers, the References from Tools in Visual Basic and post here any findings!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.