Access 2002 problem - Xtreme Visual Basic Talk

07-01-2003, 03:54 AM

opus

Newcomer

Join Date: Jul 2002

Posts: 21

Access 2002 problem

Hi!
When I convert my old Access 97 database to Access 2002, I get
"Unrecognized database format..." in VB 6.0. How can I get around this (without having to convert it back and forth all the time).

jon

07-01-2003, 06:44 AM

Anis

| Coder XXX |

Retired Leader

Join Date: Jun 2001

Location: Kuala Lumpur, Malaysia.

Posts: 3,018

Are you using ADO or DAO?. What Version of Provider are you using?

Are you using Service Pack 5 for VB? You can download it from
http://msdn.microsoft.com/vstudio/do...5/default.aspx

__________________
Regards,
Muhammad Anis Ur Rehman
Miles to go Before I Sleep.
http://www.projekcarpet.com/anis.html

07-01-2003, 06:48 AM

Shurik12

Steppe Walker

Retired Moderator
* Expert *

Join Date: Jul 2002

Location: Ukraine/Russia/Belgium

Posts: 7,227

Quote:
Originally Posted by opus
Hi!
When I convert my old Access 97 database to Access 2002, I get
"Unrecognized database format..." in VB 6.0. How can I get around this (without having to convert it back and forth all the time).

jon

Hi,
Could you show you connection string?
Using "...Jet.OLEDB.3.51..." provider...?

Shurik.

07-01-2003, 08:08 AM

reboot

Keeper of foo

Retired Moderator
* Guru *

Join Date: Nov 2001

Location: Graceland

Posts: 15,612

You need to get at least mdac 2.5 from Microsoft.

http://www.microsoft.com/data

07-01-2003, 10:15 AM

opus

Newcomer

Join Date: Jul 2002

Posts: 21

Hi - I'm using the old data control i VB, to access the tables and queries I need. By the way - I've tried to run service pack 5, but it doesn't seem to do make any difference.
Jon

07-01-2003, 01:51 PM

Flyguy

Lost Soul

Super Moderator
* Guru *

Join Date: May 2001

Location: Vorlon

Posts: 18,882

You have to choose "Access2000" instead of "Access"

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problems with VB and Access 2002	Jquiz	Database and Reporting	7	02-14-2003 08:19 AM
Access 97, 2000, 2002 on the same PC affects my app .mde connection	mikemcginty	Database and Reporting	4	01-12-2003 04:01 PM
VB or Access 2002 Problem?	verno_25_02	Database and Reporting	1	01-11-2003 12:12 AM
access 2002 runtime	pells	Database and Reporting	1	10-11-2001 12:54 AM
Problem with updating Access Databse from VB app	mellis	General	0	10-16-2000 03:27 PM