Solved

Wizzard errors in Access 95 on NT 4.0

Posted on 1998-02-04
5
204 Views
Last Modified: 2012-06-27
I am running Access 95 (Ver 7.0) on NT4.0 workstation. When using either Form or Report wizzard  the wizzard returns the error "application-defined or object-defined error" during on of the steps. This does not happen in Win 95. I have reloaded access from scratch a couple of times to try to fix any Registry problems that might be causing this.
0
Comment
Question by:ist
5 Comments
 
LVL 5

Expert Comment

by:cekman
ID: 1967502
Following is text from a MS KB article - hope it helps:

PSS ID Number: Q139041
Article last modified on 05-07-1997
 
7.0 97
 
WINDOWS
 

======================================================================
---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Access versions 7.0, 97
---------------------------------------------------------------------
 
SYMPTOMS
========
 
Moderate: Requires basic macro, coding, and interoperability skills.
 
If you use the Error() or Error$() functions to get the textual description of an error message, you may receive the following error message:
 
   Application-defined or object-defined error
 
You may receive this error message when you try to get the description of an error trapped in a form's Error event as follows:
 
   Private Sub Form_Error(DataErr As Integer, Response As Integer)
      MsgBox Error(DataErr)
      Response = acDataErrContinue
   End Sub
 
CAUSE
=====
 
The error message being trapped is Microsoft Access specific. When you pass
an error number to the Error() function that is not a Visual Basic for
Applications specific error, Visual Basic for Applications does not call
back into the hosting application to ask it for the error message.
 
RESOLUTION
==========
 
Microsoft Access 7.0 introduced the new AccessError method that you can use
to return the descriptive string associated with a Microsoft Access error
as follows:
 
   Private Sub Form_Error(DataErr As Integer, Response As Integer)
      MsgBox Application.AccessError(DataErr)
      Response = acDataErrContinue
   End Sub
 
NOTE: The AccessError method will return a string associated only with Microsoft Access errors and Visual Basic errors. It will NOT return descriptive strings associated with data access errors.
 

0
 

Expert Comment

by:npbarker
ID: 1967503
This usually happens when the folders that the wizard files are stored in do not have full read/write permissions for the current user.  This can occur if the application is installed by an adminstrator and then the normal user attempts to run the wizards.

The solution is to log in as administrator and amend the access permissions to the folders to full for everyone.

How this solves your problem.
0
 

Author Comment

by:ist
ID: 1967504
I have this problem no matter who I am logged on as. Even if I am logged on as administrator I still have this problem. NOTE: I have the same problem on all my NT machines.
0
 
LVL 5

Expert Comment

by:cekman
ID: 1967505
I recently read an article stating there was a bug with Access 95 wizards and NT. The solution was to not use them on NT (not good I know). It also stated that the problem was solved in Access 97. If you have a copy of 97 you may try converting and testing it on your NT machine just to see if it takes care of the problem.
0
 

Accepted Solution

by:
vj1 earned 100 total points
ID: 1967506
A revision of Office 95 corrects this problem.  The date on the CD is '0396 Disc Assy...'
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now