473,322 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Access 2003 database will not open using Access 2002

Hi everyone.

I am trying to open a database which works fine using Access 2003, but when
trying to open it on another PC that has Access 2002 I get the following
error

"This database is unrecognised file format, it may have been created with a
later version of Access, upgrade to a later version..."

Could anyone please help to resolve this issue.

Many thanks.

Joe.
Dec 1 '06 #1
4 2560
Use Access 2003 to decompile the database.

To decompile, create a copy, and enter something like this at the command
prompt while Access is not running. It is all one line, and include the
quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

Although Access 2002 and 2003 share the same file format, each version of
Access creates a different binary for the compiled code. What it's supposed
to do it automatically discard the 2003 binary when you open the database in
A2002, and create the new binary on the fly. In practice, this doesn't
always work. The decompile explicitly discarding the binary, which usually
solves the problem.

This issue is common enough that IMHO, it is always worth decompiling when
switching version, especially when reverting to an earlier version.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bugs" <bu*****@optusnet.com.auwrote in message
news:45**********************@news.optusnet.com.au ...
Hi everyone.

I am trying to open a database which works fine using Access 2003, but
when trying to open it on another PC that has Access 2002 I get the
following error

"This database is unrecognised file format, it may have been created with
a later version of Access, upgrade to a later version..."

Dec 1 '06 #2
Hi Allen

Thank you so much for that. Extremely appreciated.

I have performed the decompile using Access 2003 on the mdb file. I tried to
do it on the mde and it didnt work. I assume decompile is only for mdbs.

Thanks again.

Cheers.

Joe.

"Allen Browne" <Al*********@SeeSig.invalidwrote in message
news:45***********************@per-qv1-newsreader-01.iinet.net.au...
Use Access 2003 to decompile the database.

To decompile, create a copy, and enter something like this at the command
prompt while Access is not running. It is all one line, and include the
quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

Although Access 2002 and 2003 share the same file format, each version of
Access creates a different binary for the compiled code. What it's
supposed to do it automatically discard the 2003 binary when you open the
database in A2002, and create the new binary on the fly. In practice, this
doesn't always work. The decompile explicitly discarding the binary, which
usually solves the problem.

This issue is common enough that IMHO, it is always worth decompiling when
switching version, especially when reverting to an earlier version.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bugs" <bu*****@optusnet.com.auwrote in message
news:45**********************@news.optusnet.com.au ...
>Hi everyone.

I am trying to open a database which works fine using Access 2003, but
when trying to open it on another PC that has Access 2002 I get the
following error

"This database is unrecognised file format, it may have been created with
a later version of Access, upgrade to a later version..."


Dec 1 '06 #3
The MDE contains *only* the compiled binary.
Therefore it cannot be decompiled.

There's no way that the MDE created using A2003 will work in A2002.
However, the MDE created in A2002 can be used in A2003.

Each version of Access can read the binary from the versions before, but not
from later versions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bugs" <bu*****@optusnet.com.auwrote in message
news:45***********************@news.optusnet.com.a u...
Hi Allen

Thank you so much for that. Extremely appreciated.

I have performed the decompile using Access 2003 on the mdb file. I tried
to do it on the mde and it didnt work. I assume decompile is only for
mdbs.

Thanks again.

Cheers.

Joe.

"Allen Browne" <Al*********@SeeSig.invalidwrote in message
news:45***********************@per-qv1-newsreader-01.iinet.net.au...
>Use Access 2003 to decompile the database.

To decompile, create a copy, and enter something like this at the command
prompt while Access is not running. It is all one line, and include the
quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

Although Access 2002 and 2003 share the same file format, each version of
Access creates a different binary for the compiled code. What it's
supposed to do it automatically discard the 2003 binary when you open the
database in A2002, and create the new binary on the fly. In practice,
this doesn't always work. The decompile explicitly discarding the binary,
which usually solves the problem.

This issue is common enough that IMHO, it is always worth decompiling
when switching version, especially when reverting to an earlier version.
>"Bugs" <bu*****@optusnet.com.auwrote in message
news:45**********************@news.optusnet.com.a u...
>>Hi everyone.

I am trying to open a database which works fine using Access 2003, but
when trying to open it on another PC that has Access 2002 I get the
following error

"This database is unrecognised file format, it may have been created
with a later version of Access, upgrade to a later version..."

Dec 1 '06 #4
Thanks again Allen for helping sort through it all.

Cheers.

Joe.
"Allen Browne" <Al*********@SeeSig.invalidwrote in message
news:45***********************@per-qv1-newsreader-01.iinet.net.au...
The MDE contains *only* the compiled binary.
Therefore it cannot be decompiled.

There's no way that the MDE created using A2003 will work in A2002.
However, the MDE created in A2002 can be used in A2003.

Each version of Access can read the binary from the versions before, but
not from later versions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bugs" <bu*****@optusnet.com.auwrote in message
news:45***********************@news.optusnet.com.a u...
>Hi Allen

Thank you so much for that. Extremely appreciated.

I have performed the decompile using Access 2003 on the mdb file. I tried
to do it on the mde and it didnt work. I assume decompile is only for
mdbs.

Thanks again.

Cheers.

Joe.

"Allen Browne" <Al*********@SeeSig.invalidwrote in message
news:45***********************@per-qv1-newsreader-01.iinet.net.au...
>>Use Access 2003 to decompile the database.

To decompile, create a copy, and enter something like this at the
command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

Although Access 2002 and 2003 share the same file format, each version
of Access creates a different binary for the compiled code. What it's
supposed to do it automatically discard the 2003 binary when you open
the database in A2002, and create the new binary on the fly. In
practice, this doesn't always work. The decompile explicitly discarding
the binary, which usually solves the problem.

This issue is common enough that IMHO, it is always worth decompiling
when switching version, especially when reverting to an earlier version.
>>"Bugs" <bu*****@optusnet.com.auwrote in message
news:45**********************@news.optusnet.com. au...
Hi everyone.

I am trying to open a database which works fine using Access 2003, but
when trying to open it on another PC that has Access 2002 I get the
following error

"This database is unrecognised file format, it may have been created
with a later version of Access, upgrade to a later version..."


Dec 1 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
13
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine,...
0
by: Frederick Noronha \(FN\) | last post by:
---------- Forwarded message ---------- Solutions to Everyday User Interface and Programming Problems O'Reilly Releases "Access Cookbook, Second Edition" Sebastopol, CA--Neither reference book...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
5
by: j.mandala | last post by:
Someone is trying to run my Access 2002 database under Access 2003. He has had a number of problems: 1) i used the MSComCt2.ocx for it's Date and Time picker. I can't find it under 2003. Do I...
4
by: RM | last post by:
Had VS .Net 2002 installed on W2k Server SP3 and supported a number of web sites. Installed VS .Net 2003 on Friday and now all web sites using .Net & MS ACCESS get this strange error upon open. ...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
3
by: mnjkahn via AccessMonster.com | last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.