Database format not recognize when using data

[nerd_29]

hello guys! I need ur advices.... here's the problem i encountered. I use MS ACCESS as my database and the data for the connection. when i set the properties, it displays a message that says, database format not recognize. I'm using VB 6.0 and MS ACCESS 2000. Is there any other way that I can connet to the database and 1 more. How can I populate the listview with my data from the database, coz i can get it. Thank You! I really appreciate it!

[wrecklesswun]

are you using a dsn or dsnless connection ? ideally you want to use a dsnless connection., but dsn's are easier

[George1111]

What are your references to the Project?

Are you using DAO 3.6 or ADO 2.7 or above?

Earlier references will give you your symptoms

[nerd_29]

actually ADO but i realized that I still don't know the ins and outs of the ADO.

[Cakkie]

Most likely, you are using the wrong (older) provider.
To connect to an Access 2000 database, you will need to use Jet 4, not Jet 3.5.

The complete provider string is "Microsoft.Jet.4.0"

Depending on how you open your connection, you will need to change the Provider property of the connection object, or you will need to alter the provider option in the connectionstring.

[cjard]

hate to correct a moderator and all;),but the provider is Microsoft.Jet.OLEDB.4.0

here is an example connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\MadrEIs\madreis.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=True;Jet OLEDB:Database Password=this is the access database passsword

note that for access databases that have a password, you DO NOT use password=BLAH in the provider strng, you should use... jet oledb:database password=BLAH as shown above. if your database doesnt have a password, you can omit this section, which would give you a conn string of just:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\MadrEIs\madreis.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=True

[Cakkie]

hate to correct a moderator and all,but the provider is Microsoft.Jet.OLEDB.4.0

You got me there
I was just checking to see if anyone would notice... honest

[Guille2005]

Sorry, but I'm using VB 6.0, with SP6, and Access 2002, and it still does not recognize my db format.
Jet 4.0 execution is automatic with SP6, isn't it?.
May the Office XP Home, SPANISH version, be having problems?.
Thanks. Guillermo.

[mynick]

and will you please show the string...what is the provider for ms excel 97 as well as excel 2000.. for ADO as well as RDO...

tx in advance