Download: Table already exists.jpg
I had this happen some time ago and I cant remember how I got around it any suggestion ?
I have been working on a form called OrderLines the table to this form is tOrderLines
Whilst working on the form, Dataease crashed removing all the data from the table and making both the table and form un-readable,
at the same time the system created a backup table and named it temp Form 126, keeping all the data.
My question is I would now like to take back control of the data in temp form 126 and re-name it back to tOrderLines
When trying to do this by way of temp form 126 (document)(properties) (defines table) when you change the name to tOrderLinesdefine new table.
The system in forms me the table already exists. But I have deleted both the Form and the Table.
I have noted if you go in to create a new procedure the table is listed there, but cant seem to find any were else on the system.
Any help please