CAN I ACCESS DATABASES THAT WERE MADE ON NEWER VERSIONS OF ACCESS.

[Guest]

I HAVE A DATABASE THAT WAS CREATED ON ACCESS 2003 BUT MY LAPTOP ONLY HAS
ACCESS 2000. CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS 2003

tHANKS aDAM

 

[Arvin Meyer [MVP]]

Save your database to the default Access 2000 format.:

Tools ... Database Utilities ... Convert Database
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hi, Adam.

CAN DO ANYTHING TO OPEN THIS DATABASE WITHOUT UYING ACCESS 2003

If and only if the file's database format is Access 2000 database format,
you can open it with Access 2000. Otherwise, you can link to the tables in
an Access 2002-2003 database formatted file from another Access 2000 database
on your laptop. If you have to actually open the file, and the file is in
Access 2002-2003 database format, and is not an MDE file, then you'll need to
have someone with Access 2002 or Access 2003 convert the file to Access 2000
database format for you.

BTW, typing in all caps is considered shouting to Internet readers, which is
considered rude by many newsgroup readers.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Pat Hartman\(MVP\)]

Camaro, you cannot link to an A2002-2003 database from A2K. A2K cannot
recognize newer formats (Access is not alone in this failing - ALL
applications suffer from it). When A2K was written, the programmers would
have had to be prescient to have known what the file format would be several
years later. So, without exception, if the format of an application's files
changes from one version to another, the older version will not be able to
read the newer version's files.

However, Microsoft is making an effort to get around this problem with Word
and Excel. I believe they have a tool which you can download which will
allow older versions of Word and Excel to read the new XML file formats.
This will not extend to Access though.

 

['69 Camaro]

Hi, Pat.

Thanks for catching my typo.

Gunny

Camaro, you cannot link to an A2002-2003 database from A2K. A2K cannot
recognize newer formats (Access is not alone in this failing - ALL
applications suffer from it). When A2K was written, the programmers would
have had to be prescient to have known what the file format would be
several years later. So, without exception, if the format of an
application's files changes from one version to another, the older version
will not be able to read the newer version's files.

However, Microsoft is making an effort to get around this problem with
Word and Excel. I believe they have a tool which you can download which
will allow older versions of Word and Excel to read the new XML file
formats. This will not extend to Access though.

 

[dbahooker]

Pat

I sure hope that you're wrong on that.

it's called Product Racism when Microsoft builds all these crappy tools
for Excel and Word and Outlook and Project; but somehow they forget
about MS Access.

Rage Against Microsoft

I call for a boycott; a SIT-IN blocking across 520 every Friday
afternoon starting at 3pm

See you there


-Aaron