Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 24th, 2005, 05:33 PM
Registered User
 
Join Date: Mar 2005
Location: , , USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2003 Wizard Problems

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

Reply With Quote
  #2 (permalink)  
Old March 25th, 2005, 03:25 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Did you delete any system tables? This is strange.

mmcdonal
Reply With Quote
  #3 (permalink)  
Old April 15th, 2005, 03:01 PM
Registered User
 
Join Date: Apr 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #4 (permalink)  
Old April 7th, 2006, 07:09 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!

Reply With Quote
  #5 (permalink)  
Old April 11th, 2006, 03:11 PM
Registered User
 
Join Date: Apr 2006
Location: Lisbon, , Portugal.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 cantunes967@yahoo.com cheers from Lisbon. E viva o Benfica


Quote:
quote:Originally posted by serwap
 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

Reply With Quote
  #6 (permalink)  
Old April 12th, 2006, 01:57 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #7 (permalink)  
Old April 12th, 2006, 04:43 AM
Registered User
 
Join Date: Apr 2006
Location: Lisbon, , Portugal.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Reply With Quote
  #8 (permalink)  
Old April 12th, 2006, 07:14 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADO Connection problems in Access 2003 elecdave Access VBA 4 January 22nd, 2007 10:49 AM
Chart Wizard - Label Problems socoolbrewster Access 1 April 18th, 2005 11:32 AM
Upsizing Wizard in Access 2003 isolomon Access 1 January 20th, 2004 06:38 PM
Editor problems with 2003 Jerry VS.NET 2002/2003 0 July 5th, 2003 08:54 PM



All times are GMT -4. The time now is 01:36 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.