Database Unrecognized

Printable View

Jun 3rd, 2003, 10:04 AM
Stiletto

Database Unrecognized
My code is this:
VB Code:
```
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)
Jun 3rd, 2003, 10:09 AM
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.
Jun 3rd, 2003, 10:11 AM
techyspecy

Re: Database Unrecognized
Quote:
Originally posted by Stiletto
My code is this:

VB Code:

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 ....
Jun 3rd, 2003, 10:11 AM
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? :(
Jun 3rd, 2003, 10:13 AM
Stiletto

Re: Re: Database Unrecognized

Quote:

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

What do you mean in SAME ACCESS VERSION?
Jun 3rd, 2003, 10:17 AM
techyspecy

Re: Re: Re: Database Unrecognized

Quote:

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.
Jun 3rd, 2003, 10:20 AM
Stiletto

Re: Re: Re: Re: Database Unrecognized

Quote:

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...
:(
Jun 3rd, 2003, 10:22 AM
techyspecy

Do yourself a favour and install the latest version of MDAC on your machine. You can download it from www.microsoft.com
Jun 3rd, 2003, 10:27 AM
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...
Jun 3rd, 2003, 10:27 AM
Stiletto

MDAC?
If one of the users dont have the latest version, will he be able to opeb the DB?
Jun 3rd, 2003, 10:41 AM
Stiletto

Hmm..
I dont want to download MDAC.
What i did is convert the DB to 97 version. all good now.
Jun 3rd, 2003, 11:29 AM
vishalmarya

Quote:

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...

:D

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 )
Jun 3rd, 2003, 11:33 AM
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