ok did more digging and figured it out thanks to all of you for your suggestions - I wouldn't have gotten it without .. this is what I did...
went back to the original database - it was a MapInfo/excel file so tried to open that.. turns out the owner had locked the excel file - don't ask me why, it's public data so opened it in read-only mode in excel and saved it to a separate excel file.. then opened that in MapInfo and recreated the table - thank goodness x, y coordinates were there saved that file as a MapInfo file created the query again and I can now save it as a dataset so I can modify names and use it again later this was supposed to be a quick map... create a map with country/state outlines with specific points pulled from the data base, make it pretty, and give the created image to the client to include in a PowerPoint presentation... Once again THANKS!!! Barbara ----- Original Message ----- From: "Uffe Kousgaard" <[EMAIL PROTECTED]> To: "Mapinfo-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 9:31 AM Subject: Re: MI-L saving query to a separate editable table A couple of wild guesses: Your table wouldn't happen to be a so-called "linked" table? That is a kind of a view, involving 3 tab files on disk. Those are strange in some ways. You could also try to save the result as a MIF file and see if that works better. Or perhaps there are some meta data in the TAB file header that prevents saving. Regards Uffe ----- Original Message ----- From: "Barbara H. Carroll" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 6:30 PM Subject: Re: MI-L saving query to a separate editable table ok next ... 1. copy data to hard drive 2. change file attributes so they aren't read-only 3. recreate the query 4. try to save the query back to hard drive as the dataset 'test' 5. same error message "unable to create new table" this is weird Barbara --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11314 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11315
