Re: MS Access Front End

Posted in 2005

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing

Obnoxio The Clown — Thu, 2 Jun 2005 09:51:25 +0100 (BST) — source: Usenet: comp.databases.informix

Jeff Jones said: > I have a client that uses an Informix database and we have a tool > built out of MS Access that retains QA Audit information. The client > wants to use their own copy of the tool with their database files. > Question, is it possible to build an MS Access front end to an > Informix database? I just need to know the feasibility at this point. > The support group will need to create a formal change request to go > any further and actually build anything. Yes, it is feasible via ODBC. It's probably best if you are running under 9.40, because Access generates some quirky SQL that earlier versions don't handle very well (sorting by a column you didn't select comes to mind.) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list

↪ replying to Obnoxio The Clown

Jeff Jones — Thu, 02 Jun 2005 11:15:41 GMT — source: Usenet: comp.databases.informix

Thank you both VERY much. I'm nervoused by the whole request given the fact that the original developer "needed" to be able to export the MS Access tables to external databaseds so he has absolutely no table relationships. I will let folks know that technically it can be done but doing so may very add yet another level of sensitivity to the already far too sensitive Access database. Take care, Jeff On Thu, 2 Jun 2005 09:51:25 +0100 (BST), "Obnoxio The Clown" <obnoxio@serendipita.com> wrote: > > >Jeff Jones said: >> I have a client that uses an Informix database and we have a tool >> built out of MS Access that retains QA Audit information. The client >> wants to use their own copy of the tool with their database files. >> Question, is it possible to build an MS Access front end to an >> Informix database? I just need to know the feasibility at this point. >> The support group will need to create a formal change request to go >> any further and actually build anything. > >Yes, it is feasible via ODBC. It's probably best if you are running under >9.40, because Access generates some quirky SQL that earlier versions don't >handle very well (sorting by a column you didn't select comes to mind.)