472,333 Members | 1,132 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,333 software developers and data experts.

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 4238
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Edward | last post by:
My client has a database that was written in Access97. The database is password protected. If I try to open the database by double-clicking on...
2
by: Chris | last post by:
I recieve unrecognized database format when trying to open a MSAccess 2003 database with MSAccess 2000. I only need it to open as read-only. ...
2
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003...
5
by: Jerry Hull | last post by:
I'm working with a database developed by an untrained person over several years - and on a network that has recently been upgraded with a new...
0
by: Ann | last post by:
I have an Access 2000 database with 4 memo fields in it named memo1 memo2 memo3 and memo4. Some fields have data in them and some don't. If I...
1
by: eel3720 | last post by:
Greetings: I have a converted Access 2000 database that got replaced not converted to a Access 2003 Database file. Now the reports in Access...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003?...
24
by: dancer | last post by:
Using ASP.net 1.1 and Microsoft Access. I received the following error message. Why? I have closed the Access file. I have another very small...
3
by: Owen Jenkins | last post by:
I've had to reinstall XP (groan) and all my applications incl Access 97, Office 2000 and Access 2003. In doing so I believe I have installed all...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.