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)
Re: Can anyone open this MS access 1.x file for me
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.
Re: Can anyone open this MS access 1.x file for me
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
Re: Can anyone open this MS access 1.x file for me
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.
Re: Can anyone open this MS access 1.x file for me
Nope no dice visio wont open it.
Re: Can anyone open this MS access 1.x file for me
Hopefully DAO/ADO can still let you connect to it. Its not corrupt or damaged is it?
Re: Can anyone open this MS access 1.x file for me
shouldnt be
but i dont know becuase i cant open it ( access says it wont open a 1.x file)
Re: Can anyone open this MS access 1.x file for me
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.
Re: Can anyone open this MS access 1.x file for me
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.
Re: Can anyone open this MS access 1.x file for me
Make a backup copy and try to convert it first with 2005 and see how that goes.
Re: Can anyone open this MS access 1.x file for me
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
Re: Can anyone open this MS access 1.x file for 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. :)
Re: Can anyone open this MS access 1.x file for me
Re: Can anyone open this MS access 1.x file for me
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
Re: Can anyone open this MS access 1.x file for me
I know what you mean. Its almost the same price as 2003. :(