Using MS Access and ODBC

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET

Richard Krenek — Mon, 17 Apr 2000 19:57:18 GMT — source: Informix-list mailing list archive (1991-1998)

Hello all, I've been tasked with setting up MS Access to use Informix through ODBC. I have everything (I think) set up. I can do SQL queries (Pass-Through) but I'd like to be able to create reports. When i use the design wizard It lets me go to the end then I get an error message "The wizard is unable to create your report". Is there a way around this or am I missing something? Thanks for any info, Richard Krenek

↪ replying to Richard Krenek

Marat — Thu, 04 May 2000 16:28:04 +0400 — source: Informix-list mailing list archive (1991-1998)

I was doing such report and it was working fine. It works fine now too. In general I guess that if you can open linked table for browsing you can do at least simple reports based on this table. Could you tell more about your problem? Richard Krenek wrote: > Hello all, > I've been tasked with setting up MS Access to use Informix through > ODBC. I have everything (I think) set up. I can do SQL queries > (Pass-Through) but I'd like to be able to create reports. When i use the > design wizard It lets me go to the end then I get an error message "The > wizard is unable to create your report". Is there a way around this or > am I missing something? > > Thanks for any info, > Richard Krenek