When encountering this problem, I build quires in Access as a make table Query and then open that table in MI. Unfortunatly MI will not open queries from Access as MI tables, thus the Make Table Query.
William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Lars Nielsen [mailto:[EMAIL PROTECTED] Sent: Friday, September 20, 2002 02:43 To: Addison, Howard Cc: MAPINFO-L Mailinglist Subject: Sv: MI-L Can't Open Union Queries from a access database in MapInfo Hi Howy, Probably the same reason why I can't open an "inner join" in MS/SQL directly in MIPro. I.e.: SELECT * FROM table1 INNER JOIN table2 ON table1.ID = table2.ID I thought, since MIPro consequently opens all views as readonly, that the mechanics behind creating the view was irrelevant and thus transparent to MIPro, and as such, all possibly view creation mechanisms were allowed. But apparently not ! It seems that your Access/Union Query falls into the same category. Maybe someone, perhaps at MapInfo, wishes to expand on the subject ? Best regards / Med venlig hilsen Lars V. Nielsen Odense, Denmark ----- Original Message ----- From: Addison, Howard <[EMAIL PROTECTED]> To: Mapinfo List (E-mail) <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 8:09 AM Subject: MI-L Can't Open Union Queries from a access database in MapInfo > > Hi All > > Why is it so....... > > I'm trying to open a Union Query as a DBMS Table in MapInfo (Version 7.0 - > Build 26) and I get the following error. > > ODBC Error: ODBC RC=-1, ODBC SQLState=07001, DBMS RC=-3010, DBMS > Msg=[Microsoft][ODBC Microsoft Access Driver] Tow few parameters. Expected > 1.. Unable to prepare table C:\qryTenementColours.TAB. > > I can open normal tables and standard queries with no problems, but not a > union query. > > WHY ??????????????? > > Any ideas > > Many thanks > > Howy > > HOWARD ADDISON > CAD/GIS CO-ORDINATOR > AngloGold Australia Limited > Level 13, St Martins Tower > 44 St Georges Terrace > > Telephone (08) 94254649 > Fax (08) 94254663 > <mailto:[EMAIL PROTECTED]> > > > > _______________________________________________________________ > > This e-mail message contains confidential information which is > intended for the use of the person to whom it is addressed. > If you received it in error, please notify the sender and > delete the material from any computer. Any disclosure, > re-transmission, dissemination or any other use of this > information is strictly prohibited. > _______________________________________________________________ > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 3155 > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8335
