Re: Access To Oracle Program Conversion

From: Thekla Damaschke <Thekla.Damaschke_at_carmen.se>
Date: Tue, 19 Jun 2001 06:30:09 +0200
Message-ID: <3B2ED551.A9EE4C76@carmen.se>

Me wrote:
>
> Thekla, Thank you for your input. The access database is large as no data is
> purged due to year end history reasons. It quite often becomes corrupted and
> have to repair. Moving to an Oracle database would make accessing quicker
> and would not become corrupted (hopefully). I could create the tables
> needed, and write all the SQL code. I was just hoping to find a easy way
> out.
>
> Thanks again

You can use an Oracle server as backend (via ODBC) to an existing Access aplication, it works quite well and you take advantage of the transaction isolation of the server. You can use this connection to transfer the data and then use a new client to proceed working. In both cases, the only problem I had so far, was inkompatibilities in BLOB formats, especially with embedded OLE Objects. /Thekla Received on Mon Jun 18 2001 - 23:30:09 CDT