Access Format

[Khalil Handal]

Hi,
A file is in the "access 2.0 file format"
How can it be changed to "access 2003 format"?

Khalil

 

[Arvin Meyer [MVP]]

Have a look at the Access 2.0 Converter:

http://support.microsoft.com/kb/830271/en-us

 

[Guest]

I believe that it will be a 3-step process. First you'll need to find someone
with a copy of Access 97 and convert it to that format.

Second you can covert the A97 version to A03.

Third you'll need to test and find out what code does not work and fix it.

 

[Khalil Handal]

Downloade and run file.
Getting message of couruption but still have the same error of corruption
even after try to fix it??
I will try Jerry's solution and see if it works.

Thanks to both of you.

 

[Arvin Meyer [MVP]]

You will have to fix the corruption on an Access 2.0 installation before
proceeding. You cannot convert a corrupt database. I suggest that you make
several file copies before the database is corrupted further (perhaps beyond
repair)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Khalil Handal]

Tried to "compact and repair Database" but didn't work.
I think I reached a point where it is beyond repair.
What is interesting that it opens after that, but haven't try if EVERYTHING
is working
1\

 

[Arvin Meyer [MVP]]

Access 2.0 databases had separate compact and repair functions. If it opens,
it can usually be repaired.

MAKE SURE THAT YOU WORK ON COPIES OF THE ORIGINAL FILE.

If you have Access 2.0, you can almost always fix the corruption by creating
a new database and importing all the objects. Corrupted objects will not
import. You can fix them by creating a new object and copying & pasting the
controls. Once you've fixed the broken object, import it into your new
database.

Compile everything before trying to convert it. Once it compiles, it should
convert nicely.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Khalil Handal]

Thanks Arvin. Worked just fine

Access 2.0 databases had separate compact and repair functions. If it
opens, it can usually be repaired.

MAKE SURE THAT YOU WORK ON COPIES OF THE ORIGINAL FILE.

If you have Access 2.0, you can almost always fix the corruption by
creating a new database and importing all the objects. Corrupted objects
will not import. You can fix them by creating a new object and copying &
pasting the controls. Once you've fixed the broken object, import it into
your new database.

Compile everything before trying to convert it. Once it compiles, it
should convert nicely.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com