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

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

"ADAM__" <ADAM__@discussions.microsoft.com> wrote in message
news:266912BF-1045-44C2-B3DD-(E-Mail Removed)...
>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

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/ex...ributors2.html for contact info.


"ADAM__" wrote:

> 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

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" <(E-Mail Removed)_SPAM> wrote in
message news:9C245FFD-1825-466F-A686-(E-Mail Removed)...
> 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/ex...ributors2.html for contact
> info.
>
>
> "ADAM__" wrote:
>
>> 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

Hi, Pat.

Thanks for catching my typo.

Gunny


"Pat Hartman(MVP)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)_SPAM> wrote
> in message news:9C245FFD-1825-466F-A686-(E-Mail Removed)...
>> 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/ex...ributors2.html for contact
>> info.
>>
>>
>> "ADAM__" wrote:
>>
>>> 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
>
>

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





Pat Hartman(MVP) wrote:
> 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" <(E-Mail Removed)_SPAM> wrote in
> message news:9C245FFD-1825-466F-A686-(E-Mail Removed)...
> > 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/ex...ributors2.html for contact
> > info.
> >
> >
> > "ADAM__" wrote:
> >
> >> 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