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 ----- Original Message ----- From: "Kate Aulman" <[EMAIL PROTECTED]> To: "Barbara H. Carroll" <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 8:31 AM Subject: RE: MI-L saving query to a separate editable table Barbara Once you have saved the database to the hard drive make sure it is read-write, not read only. This may help, not sure. Kate -----Original Message----- From: Barbara H. Carroll [mailto:[EMAIL PROTECTED] Sent: 07 April 2004 16:38 To: [EMAIL PROTECTED] Subject: Re: MI-L saving query to a separate editable table nope - not trying to save it to cd - saving it to the hard drive and error message is "unable to create new table" I'll try copying the database to the hard drive and seeing if that works Will let you know Barbara ----- Original Message ----- From: "Cinda Graubard" <[EMAIL PROTECTED]> To: "Barbara H. Carroll" <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 8:19 AM Subject: Re: MI-L saving query to a separate editable table are you trying to save it to the cd? can't do that. cinda At 09:08 AM 04/07/2004, you wrote: >ok looks like I need to give you a more information on the data.. > >the original table is a read-only CD - that is correct and contains >several thousand records - I'm interested in about 10 >I use the query->select function to build the query and select the records >I need to work with in this case 'query2' >once I've created my selection I then go to file->save copy as... >and select my query - 'query 2' >the error message is "unable to create new table" > >I just redid the steps I went through to make sure I wasn't missing anything. >So what am I doing that isn't correct?? > >Barbara > > ----- Original Message ----- > From: Patrick Chance > To: [EMAIL PROTECTED] > Sent: Wednesday, April 07, 2004 7:48 AM > Subject: Re: MI-L saving query to a separate editable table > > > Barbara > > You should be able to save the query, using "Save Copy As", if you > select the Query, at the bottom of the file list if it was your most > recent query. It seems that you may be trying to save the original file, > which being open cannot be saved as itself. > > Patrick > > > > On 4/7/2004 10:41:50 AM, Barbara H. Carroll ([EMAIL PROTECTED]) wrote: > > I have a query that > > I'd like to save as a separate table that I can then edit and > manipulate separately. When I try to save it using 'save > > > copy as...' I get an error. and when I use the 'save query' command, > it's > > saved as a query that's linked back to the original table that I can't > > edit. How do I get this to work?? > > > > Barbara Carroll --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11311 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11313
