Can anyone open this MS access 1.x file for me

[Crash893]

Hi all,

Im updateing some olllllllllllllld old program ( vb3) and it has an access file that i cant open becuase i have access 2003

Can anyone open this file and convert it to something a little higher so i can open it ( i just dont have access(pun) to an older version)

[RobDog888]

If you have Visio you can do a reverse engineering on it (hopefully) and get a schematic of all objects and data types. Then you can redesign in 2003 similarily.

[Crash893]

ill give it a try

I think there might be old data in it that i might need to harvest but ill take a look at the visio route

[RobDog888]

Can you connect to it using DAO/ADO and retrieve the data then? If you can connect using DAO/ADO you can open the db schema and get most of the structure that way for duplication in 2003.

[Crash893]

Nope no dice visio wont open it.

[RobDog888]

Hopefully DAO/ADO can still let you connect to it. Its not corrupt or damaged is it?

[Crash893]

shouldnt be
but i dont know becuase i cant open it ( access says it wont open a 1.x file)

[Crash893]

I can partial open it in vb2k5

but when i try to get a better look at the table i get

This property is not supported for external data sources or for databases created with a previous version of Microsoft Jet.

[RobDog888]

Documentation on MSDN only goes bak to Access 95.

I couldnt even find it on google. IU was thinking that maybe it would be dirt cheap to buy the software or a version like 2-3.0 so you can convert it up or at least open it.

[RobDog888]

Make a backup copy and try to convert it first with 2005 and see how that goes.

[Crash893]

Make a backup copy and try to convert it first with 2005 and see how that goes.

that is exactly what i have been trying to do

it wont let me

[RobDog888]

I found this...

It's not possible to do a direct conversion of forms and
reports from 1 to 11. You need to use 2, 7, or 8 (2, 95, 97)
to convert to 2, 7, or 8 first, then convert from 2,7,8 to
version 11.

However, you can convert data from 1 without an intermediate
version.

I couldnt find 1 or 2 so I will look for 95 or 97 now.

[RobDog888]

Looks like this Access chart will show that you will be able to convert your 1.x db with Access 97.

http://www.lle.rochester.edu/pub/sup.../ConvFile.html

http://www.checknowsoftware.com/uk/s...d.asp?pid=1965

eBay price $110.00
http://cgi.ebay.com/Microsoft-Office...ayphotohosting

[Crash893]

noooo no no no

no way am i paying for access 97

I appreshate the the help though

I will start asking questions to the it department to see if we have an old copy some where

[RobDog888]

I know what you mean. Its almost the same price as 2003.