Solved

Access 2.0 error 3000 from VB 3.0

Posted on 1997-08-07
3
263 Views
Last Modified: 2009-07-29
What is an error 3000 (described only as "Reserved")?
I get it when doing an .AddNew on either a Table or Dynset recordset object to an Access 2.0 Database from Visual Basic 3.0.  Also, at this point the database becomes corrupted and must be recovered.
0
Comment
Question by:keyboards
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:keyboards
ID: 1955542
Edited text of question
0
 
LVL 4

Accepted Solution

by:
ozphil earned 150 total points
ID: 1955543
Have you insallled the Access 2 service pack, which updates the Jet DLL from 2.0 to 2.5.

Not all error messages are available to VB3 when using access 2. These are then labelled 3000.

The service pack may clear some of these error messages.

The corruption problems should be prevented once the service pack is installed. It is available from Microsoft online.

Also, if you try to run equivalent code or query from the Access 2 environment, you may see more clearly what the error message is.

0
 

Author Comment

by:keyboards
ID: 1955544
Good instructions about the service pack.  However, installing it changed nothing.  It all boiled down to recompacting the database, and that has apparently fixed it.  I've seen error messages that indicate to do this specifically, but with a 3000 error I didn't have a clue.  
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

729 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