469,271 Members | 1,141 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Why you can't open Access 2003 db with Access 2000

Hello Access gurus,
I am curious as to why you can't open an Access 2003 Db with Access
2000. We have a Visual Basic application which is using DAO 3.6 to
connect to the Access database. It IS able to open an 2000 and 2003 Db
because they are all in Jet 4 database format, I assume. But when
trying to open an Access 2003 Db from Access 2000 you get the
'Unrecognized database' Error. Aren't they the same database structure
and the only difference is within the Access program??
Thanks for your help in advance.

Nov 13 '05 #1
2 4133
pl*****@hotmail.com wrote:
Hello Access gurus,
I am curious as to why you can't open an Access 2003 Db with Access
2000. We have a Visual Basic application which is using DAO 3.6 to
connect to the Access database. It IS able to open an 2000 and 2003 Db
because they are all in Jet 4 database format, I assume. But when
trying to open an Access 2003 Db from Access 2000 you get the
'Unrecognized database' Error. Aren't they the same database structure
and the only difference is within the Access program??
Thanks for your help in advance.


The data is the same format but other things like code, forms, reports,
the things that you wouldn't look at in VB but would with Access are
different.

You have to remember when you're using Access, you're using two things,
a front end (Access) and a database (Jet).

--
This sig left intentionally blank
Nov 13 '05 #2
When you are opening with VB all VB cares about is the Jet tables. Jet
table structure hasn't changed since A2000.

Access on the other hand is opening an Access application including all
the UI objects as well as the tables. This, in principle, is version
specific.

Peter Russell
previously wrote:
*From:* pl*****@hotmail.com
*Date:* 12 Jan 2005 10:01:08 -0800

Hello Access gurus,
I am curious as to why you can't open an Access 2003 Db with Access
2000. We have a Visual Basic application which is using DAO 3.6 to
connect to the Access database. It IS able to open an 2000 and 2003 Db
because they are all in Jet 4 database format, I assume. But when
trying to open an Access 2003 Db from Access 2000 you get the
'Unrecognized database' Error. Aren't they the same database structure
and the only difference is within the Access program??
Thanks for your help in advance.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Edward | last post: by
24 posts views Thread by dancer | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.