Access Format

K

Khalil Handal

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

Khalil
 
J

Jerry Whittle

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.
 
K

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.
 
K

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\
 
A

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
 
K

Khalil Handal

Thanks Arvin. Worked just fine


Arvin Meyer said:
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
Click to expand...
 
Top