Access 95

[fauzulhq]

Hi ,
My software runs on an Access 95 database. I have been trying to link the database to a SQL server but the external data tab is locked. However the export section works but I need to link the database ( ODBC Database ) for me to update the data in real time.

Its actually for my E-Commerce store. Right now I am dumping the file which takes about 2-3 hours, and then upload it to my web server.

I cannot convert the database to an earlier version ( 2000 or 2003 ) because the software only reconise access 95 ( damn not even 97 ).

Please Help, I have been looking around for 2 week but no result.

 

[Simon_MT]

What is your scripting language in your E-Commerce Site. Is it using connection strings? And to what database SQL Server or Access?

Simon

 

[SOS]

The problem is that the Access program is so out of date that it probably can't connect to a SQL Server version higher than possibly 6.5 and maybe 2000. So if you are trying to connect to a 2005 or 2008 SQL Server I am pretty sure you are basically out of luck.

 

[fauzulhq]

What is your scripting language in your E-Commerce Site. Is it using connection strings? And to what database SQL Server or Access?

Simon

We are trying on My Sql for now but if there is a way to do it in MS Sql , no harm in trying.

 

[fauzulhq]

The problem is that the Access program is so out of date that it probably can't connect to a SQL Server version higher than possibly 6.5 and maybe 2000. So if you are trying to connect to a 2005 or 2008 SQL Server I am pretty sure you are basically out of luck.

' you are basically out of luck ' - At some point I agree with you , but not giving up yet.............

 

[fauzulhq]

I'm using PHP and mysql. Is there any possibility to know if the access 95 database is locked for using the get external data function? If yes, how do i unlock the table? I've tried converting the database to version 2000-2003, and i'm able to use the get external data option. When I tried opening the access 95 database, the option is greyed out. Thank you.