?
Solved

Visual Basic 6.0 and Access 2000

Posted on 2003-03-20
13
Medium Priority
?
221 Views
Last Modified: 2013-11-25
Does anyone know why VB won't recognize a access 2000 database but it will recognize a access 97 db?  If so does anyone know how I can fix that?
0
Comment
Question by:bjshay
[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
  • 3
  • 2
  • +5
13 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 152 total points
ID: 8178742
0
 
LVL 2

Expert Comment

by:spauljoseph
ID: 8178820
VB 6.0 can support any version of MS Access. But the components you used to access the database will differ. For example, if you used DAO (Data Access Objects) or DataControl then it will support only up to MS Access '97 because they've written before MS Access 2000 came. But you can use ADO (ActiveX Data Objects) which are written to use with any MS Access database. This comes with the control named ADODC (ActiveX Data Objects Data Control) you can use this in your form for accessing any Access version databases. You can also use these ADO using code by just adding Microsoft ActiveX Data Objects 2.0 Library to your Project References and just place them in form as follows.

Dim con as New ADODB.Connection
Dim rst as New ADODB.RecordSet

Private Sub Form_Load()
   con.Open "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & App.path & "\YourDb.Mdb"
   rst.Open "Select * from YourTable",con,adOpenDynamic,adLockOptimistic
End Sub

'NOTE: for more information about ADO, please refer to the MSDN online at http://msdn.microsoft.com/library

0
 
LVL 1

Assisted Solution

by:Sankar_V
Sankar_V earned 148 total points
ID: 8179262
Download the VB6.0 Service Pack 5!

That will do the needfull!



0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 5

Expert Comment

by:Cimperiali
ID: 8179662
Or goto www.Microsoft.com and make a search for "Jet" (as latest jet update is not included in latest Mdac_typ.exe)
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 8179704
Some versions of VB often don't recognize the newer versions of Access but recognize the old ones. For that, you can work with the older version but you have to convert the newer version to an older version. VB will perform all transactions into that older version perfectly and you need not be bugged thinking that its an 'old' version.

Open the .mdb file in Access 2000, and go to Tools, then Database Utilities, then Convert Database, then To Prior Database Version, and specify a different filename. Use this new .mdb file for your VB program, and I think that everything should work fine.

Mayank.
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 8184269
Yes! u r right mayan! Also, note that using access 2000 u will not be able to use ADODC control. All other controls can be used though. But, still u can work with ADODB as suggested by spauljoseph.
Thanks
Sam
0
 

Expert Comment

by:CleanupPing
ID: 8531909
Hi bjshay,
This old question (QID 20558207) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 
LVL 6

Expert Comment

by:GPrentice00
ID: 8982593
This question has been classified as abandoned.  I will make a recommendation to the moderators on its resolution in a week or two.  I would appreciate any comments by the experts that would help me in making a recommendation.
It is assumed that any participant not responding to this request is no longer interested in its final deposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help/closing.jsp

GPrentice00
Cleanup Volunteer
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8982629
Recommandation: Accept emoreau's comment
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 8982639
Recommendation: Accept mayankeagle's comment :-) :-)
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8982654
Your comment suggest that the database is converted. It is not always possible because the database must be used by older system.
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 8982690
Yeah, but you don't know what the case is with him. God knows whether it helped him or not. He never cared to post another comment here :-)

Mayank.
0
 
LVL 6

Expert Comment

by:GPrentice00
ID: 9046098
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->Split between emoreau and Sankar_V

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

765 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