Philip Villars wrote: > Hello Chuck, > >> I have several Access .mdb files which have different information. >> When I try to open them with Maptitude, it always only displays the >> first one I opened. I do not recall having this issue in the past, >> has anyone seen this one? I do open file >> Select ODBC table >> Select Access >> >> At this point it shows me one table, the first one I opened and will >> not show anymore of the access files I have. > > This is because the MS Access ODBC driver "remembers" the last mdb > file you used. The MS Access ODBC driver does something it's not > supposed to, here. It provides "itself" as a datasource, with the > intention being that you'll specify the mdb file you want to use > "on the fly". This goes against how ODBC was designed -- you're > supposed to "pre-configure" your odbc source in advance, using the > "ODBC Administrator" control panel item. Configuring an ODBC > source means picking a driver, choosing a database (an MDB file > in the case of MSACCESS), choosing any database-specific options, > and saving the whole mess as a "datasource". > > To use ODBC to access MS Access data properly, use the ODBC > Administrator control panel to set up your desired mdb file as > a datasource, then this datasource from the File-Open-"ODBC Table" > command. > > Hope this helps. >
Philip, Thank you much. Indeed what I did was stuff all of my tables in one file, that was the quick and dirty. It works for what I am presently doing, but will have to use the other path when I have to do separate db files for each table. I am going to move to MySQL anyhow, and that will take care of that issue (I hope) Access keeps on doing other weird things that are at best small bother, and at worst really bring out the worst in the product. But for now it is quick and I can see my changes on the map without having to do a lot. As usual a quick response. Thank you again. Chuck Hast ------------------------------------------------------------------------- To paraphrase my flight instructor; "the only dumb question is the one you DID NOT ask resulting in my going out and having to identify your bits and pieces in the midst of torn and twisted metal." ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/C5grlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Maptitude/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
