Database Unrecognized

[Stiletto]

My code is this:

Private Sub Form_Load()
   Dim Db As Database
   Set Db = OpenDatabase(App.Path & "\Stilo DB.mdb")
End Sub

I got This error:
Unrecognized Database format
What is the problem?
(I got MS Access 2002 XP)

[Buzby]

Just out of interest, try renaming the .MDB file so it doesn't have a space in the filename, and then see if it works...

Also what does App.Path have in it at the time?

Do a

Msgbox App.Path

before the OpenDatabase line to see what's in it.

[techyspecy]

Originally posted by Stiletto
My code is this:

Private Sub Form_Load()
   Dim Db As Database
   Set Db = OpenDatabase(App.Path & "\Stilo DB.mdb")
End Sub

I got This error:
Unrecognized Database format
What is the problem?
(I got MS Access 2002 XP)

Did you create the MDB file in same access version ....

[Stiletto]

I know whats in it. Its the app path
I think it has something to do with the DB
I have here an old DB from 97, and i can connect to him with no problems at all.

what is wrong with access XP 2002 version?

[Stiletto]

Originally posted by techyspecy
Did you create the MDB file in same access version ....

What do you mean in SAME ACCESS VERSION?

[techyspecy]

Originally posted by Stiletto
What do you mean in SAME ACCESS VERSION?

Is the MDB file was created in Access 2002 XP which you have on your machine or it was created in some earlier Access version ? If it was created in earlier version then you're gonna have to upgrade it to latest version.

[Stiletto]

Originally posted by techyspecy
Is the MDB file was created in Access 2002 XP which you have on your machine or it was created in some earlier Access version ? If it was created in earlier version then you're gonna have to upgrade it to latest version.

Check this out, this is weird:

I created this DB from the Access which is installed in my comp.
A friend sent me an old version (97) DB.
Weird is that i can connect to the old version DB not THIS one...

[techyspecy]

Do yourself a favour and install the latest version of MDAC on your machine. You can download it from www.microsoft.com

[evexa]

I got the same error when using access 2k with VB.
It doesnt work!
search the forum for 'unrecognised database format' for more info...

[Stiletto]

MDAC?
If one of the users dont have the latest version, will he be able to opeb the DB?

[Stiletto]

Hmm..
I dont want to download MDAC.
What i did is convert the DB to 97 version. all good now.

[vishalmarya]

Originally posted by evexa
I got the same error when using access 2k with VB.
It doesnt work!
search the forum for 'unrecognised database format' for more info...

if u are using dao , Access jet engines should be considered

Access 97 - Ms Jet engine 3.5 same as dao 3.51

Access 2000 - Ms jet Engine 4.0 Same as dao 3.6

Access 2002 (Xp) - Ms jet Engine 4.0 Same as dao 3.6

one more problems will be faced if u use data control
(everybody runs towards ado control anyway ) , it won't connect to access 2000 or Access 2002 ( Xp )

[Stiletto]

k tnx
Can you plz help me to read data from the DB, in this post:
http://www.vbforums.com/showthread.p...hreadid=247950