Solved

Does anybody know whether the Visual Basic 6.0 compatible with Access of Office 2000 or not?

Posted on 2002-03-13
10
161 Views
Last Modified: 2013-11-25
Hi, All,

Does anybody know whether the Visual Basic 6.0 compatible with Access of Office 2000 or not?

I have installed both Office 2000 and Visual Studio 98 on my computer. I would like to develop a database with Visual Basic and Microsoft Access. But with no success

I created a database in the MS Access first, then created a user interface on Visual Basic 6.0.  When I set RecordSource property at run time, the following error message was shown: “Unrecognized database format”

I tried another approach to this problem by creating a database at ”Visual Data Manager…” under  “Add-Ins” in the Visual Basic 6.0.  I can set properties such as DatabaseName, RecordSource, Field, etc.  However, when I click AddNew button to implement code “Data1.Recordeset.AddNew”, I got error message: “Run-time error ‘3426’ This action was cancelled by an associated object.”

What is the problem?

Thanks,

Anlee
0
Comment
Question by:Anlee
[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
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 43

Expert Comment

by:TimCottee
ID: 6861015
The original version of VB didn't have support for access 2000. SP5 does have support in some of the intrinsic controls for access 2000. Otherwise you need to ensure that you are referencing Microsoft ActiveX Data Objects 2.1 or higher if using ADO or if using DAO then version 3.6 rather than version 3.5. The earlier versions will not support access 2000. To use the data control that you appear to be trying to use you really should go to Service Pack 4 or higher (5 is available).
0
 
LVL 4

Expert Comment

by:trkcorp
ID: 6861033
You need to get and run the latest version of MDAC_TYP.EXE Which will upgrade all of your DB drivers & so forth.  This is also, I believe, bundled with SP 4 or better.  I suggest you get service pack 5 and see if your problems don't clear up.
0
 
LVL 4

Expert Comment

by:trkcorp
ID: 6861063
http://www.microsoft.com/data/download.htm
You can find MDAC_TYP.exe there...
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 43

Expert Comment

by:TimCottee
ID: 6861110
MDAC will upgrade the available drivers indeed, however MDAC 2.6 and higher doesn't include the jet drivers which you can download seperately. Nor will it allow the intrinsic data control to support access 2000. You need SP4 or higher as already suggested to do this.
0
 

Expert Comment

by:bill02
ID: 6861249
Tim is right on using 3.6 instead of 3.5 but in code your record source must also have your provider as Microsoft.Jet.OLEDB.4.0 see example

recordsource = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Persist Security Info=False"

a common mistake is people still use oledb.3.51 this should be all you need between what me and tim have told you
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 6863488
bill02

Anlee is asking about DAO not ADO.

Anthony
0
 

Author Comment

by:Anlee
ID: 6868303
Hi, All,

Thanks for your help. I now know that “the original version of VB didn't have support for access 2000” from your help.

Unfortunately, I separately downloaded “jet40SP5_9xNT.exe” and “mdac_type.exe”(2.6) to try it, the same error message was appeared. Do you know what’s wrong with it?  Maybe I should install office 1997. Thanks again.

Regards,

Anlee
0
 
LVL 43

Expert Comment

by:TimCottee
ID: 6868336
Unless you have upgraded the data control then it still wont work unless you use code and reference the new dlls directly.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 50 total points
ID: 6868398
This article from MSDN, gives all the details and workarounds when using the DAO Data Control:
PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or 2002 (Q238401)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q238401

Anthony
0
 

Author Comment

by:Anlee
ID: 6869274
Expert Anthorry ,

I have  gotten  good result from your help.

Thank you very much,

Anlee
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Advice in Xamarin 21 121
C# LINQ ForEach() question 6 117
VB script to continue despite error 2 78
Access 2003, find all instances of database ODBC 3 53
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

752 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