By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.