Hi Ron, Are you asking how to correct an error in data input or are you asking how to correct an error in defining a column in a table.
In the first case, an error in data entry, you can use a standard SQL UPDATE command. However, I think you mean the later. If you need to change the data type of an existing field and the table editor is not allowing it, it may be because the database engine is not allowing it. In any case it should be offering to drop the column and add it at the end of the table for you. If you have data in it, you most likely keep answering no to that. In the case of an embedded Base database you could try issuing an ALTER TABLE command directly in SQL command window. Failing this working then you will need to a) Copy your table to a new one. b) drop the column in the original table then add it back with appropriate changes c) transfer the data from the column in the 'Copy' back to the new column in 'Original' d) delete the copy of the table Andrew 'Drew' Jensen On 4/2/07, Ron Horsley <[EMAIL PROTECTED]> wrote:
Hi, Can someone please advise how I can correct an error in a field in a db. I keep getting stuck in Design View that does not allow editing of fields but this facility is essential for updating records and error correcting and the help pages give me no alternatives. Thanks, advice will be appreciated. Ron. H Warwickshire England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
