I'm having problem. When I try to run either a Form Wizard, or a Report Wizard, The tables and queries i've created appear in the drop down box, but when I highlight the desired table the available fields window remains blank/empty. I'm running Access 2003 /XP-Pro+SP2 /Office 2003 + SP1.

Thanks Steve

Did you delete any system tables? This is strange.

mmcdonal

Steve, have you found the solution in the meantime?

I have the same problem: Access 2003 wizards fail to work. Examples:
1. If I create a new database with a table and some columns, then the wizards (like query wizard) will not see the columns).
2. Tools/Analyze/Table return "division by zero" error message by invocation of the wizard
3. VBA script seem to be partially blocked.

The error is independent of the database file: I get the same error opening various .mdb files.

Reinstalling of access did not help, nor reparation of registry with registry repair tools.

I have XP SP2 + Access 2003 with both latest online updates.


Thanx Piotr

Are either of you gents using Kaspersky antiivirus?

I have JUST solved the same problem by permitting the AV system to run VB scripts (bit of a control freak Kasperksy, and not the first time I've had problems with it and Access)

Even if NOT Kaspersky , which seems to be a VERY consistent offender in this area, you may have some other software which is blocking VB scripts/VBA - bit of a downer when developing in Access!

I have the same problem it's driving me crazy... please anyone has a solution ? The Macro security stuff didn't help. I'm running XP SP2 and office 2003. my e-mail is [email protected] cheers from Lisbon. E viva o Benfica

Hi Cantunes

You didn't say what antivirus/security suite you're running on your computer - I've found this to be a REAL problem with Access over the last two years due to the way that Access runs the wizards.

Please post again with a fuller list of your security software, and I'll see if I can help

Chrisalis

Hi Chrisalis,
- I'm using Msafee Viruscan Enterprise 8.0 (updated)
- Also Microsoft Antispyware (this wouldn't mess with scripts !??)
I've tried dozens of solutions I've been gathering, but nothing
Clue: In some mdb files when I call the vb editor, msg"Can't create visual basic module" I accept and it does create, go figure.

Other clue: In a command button wizard to open a form, the list of the forms appears to be empty, so I can not select a form.

Still looking at this for you, cantunes - all the symptoms you have are pointing to the same problem (AV software blocking VB script) - unfortunately, I dont have McAfee to hand to tune around with (I won't have it or Norton in the house!) - so Im scanning around for some other info elsewhere

Meanwhile - have you tried disabling AV (whilst offline of course) - and checking if things are working then?

If I understand your post correctly, this problem is not consistent across all databases? - if so, it ISNT the script blocking scenario; May I ask, have you tried a reinstall of Access into a different location? - or even under a different user profile on the same machine - are the symptoms consistent then?