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

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)

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.

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

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.

Nope no dice visio wont open it.

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

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

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.

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.

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

Quote:

---

Originally Posted by RobDog888

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

I found this...

Quote:

---

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. :)

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

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

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