PC Review


Reply
Thread Tools Rate Thread

Can you use an Access2002 mdb in Access2000?

 
 
Chello
Guest
Posts: n/a
 
      11th Mar 2005
Is it possible to open an MDB, made with Access2002, in Access2000? Most
articles that I read about it say that the mdb's between the two versions of
Access are binary compatible. However, when I try to open the 2002 database
in Access2000, I get an 'unrecognized format' error.


 
Reply With Quote
 
 
 
 
Brendan Reynolds
Guest
Posts: n/a
 
      11th Mar 2005
By default, Access 2002 uses the same format as Access 2000. There is,
however, an optional new Access 2002 format. If you have used that format,
you will not be able to open the MDB in Access 2000. Access 2002 can,
however, convert to the earlier format.

See Tools, Options, Advanced, Default File Format to determine which format
your installation of Access is using, and see Tools, Database Utilities,
Convert Database for the conversion feature.

--
Brendan Reynolds (MVP)

"Chello" <(E-Mail Removed)> wrote in message
news:FJgYd.370410$(E-Mail Removed)...
> Is it possible to open an MDB, made with Access2002, in Access2000? Most
> articles that I read about it say that the mdb's between the two versions
> of
> Access are binary compatible. However, when I try to open the 2002
> database
> in Access2000, I get an 'unrecognized format' error.
>
>



 
Reply With Quote
 
Marsela
Guest
Posts: n/a
 
      11th Mar 2005
I do work with Access 2000 and Access XP 2002. I open the
database from Wind. 2002 to 2000, in that case it doesn't
ask you for converting as it converts automatically, but
you have to change the References that you are using for
running VBA codes and so. (some of the references are
different from 2000 in 2002) If you don't change, would
give you error message for sure.

Marsela Alushaj
MOS - MCP
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
sharing Access files between access2000 and access2002 Bill Microsoft Access 2 25th Dec 2003 06:00 PM
11 Oct 2003, Access2002(XP) , Whats new in Access2002 compared to Access2000 Sham Yemul Microsoft Access 1 11th Oct 2003 06:34 AM
Access2000 queries flakey in Access2002 Tom Conroy Microsoft Access Queries 0 10th Sep 2003 05:01 PM
Button created in Access2002 doesn't work in Access2000 Joe Strayer Microsoft Access Forms 0 7th Jul 2003 06:53 PM
Systemdb works in Access2000 but some problem in Access2002 Sumesh Microsoft Access Security 0 26th Jun 2003 02:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:36 AM.