?
Solved

Access 2.0 error 3000 from VB 3.0

Posted on 1997-08-07
3
Medium Priority
?
265 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 450 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

764 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