Solved

VB6 and Access 2002

Posted on 2002-05-05
4
154 Views
Last Modified: 2010-05-02
I have an app that works fine from VB4 and uses an Access 97 database. I upgraded to Office XP and I get an error "Unrecognized database format..." I copied the code into a new form to test and get the same thing.

Is there anything to do with Access 2002 databases in VB?
0
Comment
Question by:rahlf192
[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
4 Comments
 
LVL 4

Expert Comment

by:mcoop
ID: 6990628
I don't have OfficeXP - but my guess is that you will have to open the project-references, and update the libraries to point to a new 'Access 2002' class.  (It may be called Access 10 or something else) - but you get the idea.

The recompile, and if all the objects are structured the same in XP as they were under 97/2000 then you should be on your way.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 50 total points
ID: 6990694
DAO or ADO?

Take a look at the following article on MSDN:
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&SD=MSKB&

Also, please maintain your open questions:
Questions Asked 36
Last 10 Grades Given A A B B B B A A A A  
Question Grading Record 25 Answers Graded / 25 Answers Received

Anthony
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6990738
In VB6, we need to use DAO 3.60 or ADO 2.0. Can you use them with VB4?
0
 
LVL 1

Expert Comment

by:ramani_gr
ID: 6991070
When you install the Office XP, the DAO version must have been changed to a new version.  It won't read the old format.

Open the Access 97 database in Access 2002.  It would ask you to convert to the Access 2002 format.  Save to a new Access format.  And rename the Access97 database file to some old.  And rename the Access2002 new version database to the actual file name.

Good luck.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
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 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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month7 days, 19 hours left to enroll

617 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