• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

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

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
Anlee
Asked:
Anlee
  • 3
  • 2
  • 2
  • +2
1 Solution
 
TimCotteeHead of Software ServicesCommented:
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
 
trkcorpCommented:
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
 
trkcorpCommented:
http://www.microsoft.com/data/download.htm
You can find MDAC_TYP.exe there...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
TimCotteeHead of Software ServicesCommented:
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
 
bill02Commented:
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
 
Anthony PerkinsCommented:
bill02

Anlee is asking about DAO not ADO.

Anthony
0
 
AnleeAuthor Commented:
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
 
TimCotteeHead of Software ServicesCommented:
Unless you have upgraded the data control then it still wont work unless you use code and reference the new dlls directly.
0
 
Anthony PerkinsCommented:
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
 
AnleeAuthor Commented:
Expert Anthorry ,

I have  gotten  good result from your help.

Thank you very much,

Anlee
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now