PDA

View Full Version : MS Access to Informix Migration ???


RDBMS
12-22-01, 12:48
Hi,

My application is on Access 97 forms & reports with Access database.
As per the business requirement the volume of data grows every day,hence we choose to
change the back end from Access to Informix.To retrive/modify/delete data from Informix through
Access forms, if link table technique is used,
will it have any impact of MS Access database's limitations when more volume of data is retrived
from informix.Whether the query execution is on MS Access engine or Informix engine?
Can you give us any other advantages/disadvantages using Link table technigue in MS Access to
retrive/modify/delete data from informix.Any other better technique to retrive/modify/delete
informix data from Acces 97 forms & reports.

cmgood13
09-12-02, 15:59
How are you linking MS Access to Informix. I am new to this and I need to link Access to Informix and have been unsuccessful using odbc.

Roelwe
09-16-02, 05:33
The best way is to let Informix handle the SQL optimization.
Don't try to load entire tables to yr client.
I know there are some ways in Access...