Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Access Format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Khalil Handal - 30 Jul 2007 18:47 GMT
Hi,
A file is in the "access 2.0 file format"
How can it be changed to "access 2003 format"?

Khalil
Arvin Meyer [MVP] - 30 Jul 2007 19:17 GMT
Have a look at the Access 2.0 Converter:

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

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi,
> A file is in the "access 2.0 file format"
> How can it be changed to "access 2003 format"?
>
> Khalil
Khalil Handal - 30 Jul 2007 19:53 GMT
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.

> Have a look at the Access 2.0 Converter:
>
[quoted text clipped - 4 lines]
>>
>> Khalil
Arvin Meyer [MVP] - 30 Jul 2007 20:33 GMT
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)
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Downloade and run file.
> Getting message of couruption but still have the same error of corruption
[quoted text clipped - 11 lines]
>>>
>>> Khalil
Khalil Handal - 30 Jul 2007 20:48 GMT
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\

> 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
[quoted text clipped - 15 lines]
>>>>
>>>> Khalil
Arvin Meyer [MVP] - 30 Jul 2007 21:10 GMT
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.
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Tried to "compact and repair Database" but didn't work.
> I think I reached a point where it is beyond repair.
[quoted text clipped - 21 lines]
>>>>>
>>>>> Khalil
Khalil Handal - 30 Jul 2007 22:38 GMT
Thanks Arvin. Worked just fine

> Access 2.0 databases had separate compact and repair functions. If it
> opens, it can usually be repaired.
[quoted text clipped - 34 lines]
>>>>>>
>>>>>> Khalil
Jerry Whittle - 30 Jul 2007 19:18 GMT
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.
Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi,
> A file is in the "access 2.0 file format"
> How can it be changed to "access 2003 format"?
>
> Khalil
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.