VB6 and Access2000

[esimuro]

I have been creating VB applications using access databases for some time now. I have recently attempted to port an existing application written in VB6 with Access97 to Access2000. I can successfully open and query the database but when I attempt to use a simple data control I get an error "unrecognized database format".

How can I deal with Access2000, in reviewing your site I found a comment which said to convert the database back to Access97 format, however this doesn't appear to be a valid alternative for commercial software where the database is used by the application as well as other uses.

[Feras]

Go to microsoft home page and seartch for the "visual stodio 6.0 service pack 4" it will solve your problem.

[maqmaq]

Feras
I have SP4 and stil got the same problem with Access2000, Are you doing OK with SP4,,Please advise

[esimuro]

After you install SP4, you will have to change the "connect" property of the Data control to Access 2000. In my limited testing this works for both Access 97 and Access 2000.

Originally posted by maqmaq
Feras
I have SP4 and stil got the same problem with Access2000, Are you doing OK with SP4,,Please advise

[maqmaq]

I follwoed what you suggested and it work Ok, However still I am having a problem on openning the protected data base by using the following code:

On Error Resume Next

Dim podata As Database
DatabaseName = "c:\trackit.mdb"
mypassword = "today1"
pwdm = ";pwd=" & mypassword & ""
Set podata = OpenDatabase(DatabaseName, False, False, pwdm)

When it's running, error occurred that password is not valid,,
Did you try Access 2000 protected data base with SP4,, Please help
Thank