Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2001
    Location
    India
    Posts
    3

    Unanswered: MS Access to Informix Migration ???

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    3
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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...
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •