• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 879
  • Last Modified:

"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.
0
tapkep
Asked:
tapkep
  • 4
  • 3
1 Solution
 
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
 
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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now