|
|
Archives of the TeradataForum
Message Posted: Fri, 28 Oct 2004 @ 22:14:23 GMT
Subj: | | Re: SQL Assistant History Question |
|
From: | | McCall, Glenn D |
Also, when you open the history file in a newer version of MS-Access, it will offer to convert the table to the new format.
While I have never accepted the offer to convert; it probably isn't a good idea to convert it as it may "corrupt the file" in the sense that
queryman may still be using the older access methods to store history (and doesn't recognise the new format).
Also, the offer to convert to the new format contains a warning which is slightly misleading. Some people interpret the warning to mean that if
they don't convert, they won't be able to modify the database. What this is referring to is that you can't modify the structure (i.e. add tables,
drop tables etc), you will still be able to view the content of tables, insert, delete and update rows.
Good Luck
P.S. If the above is the cause of your problem, you could always follow the process Phil has proposed to create a new history file. Then
copy and paste the "corrupted" file to the new file Queryman has created.
| |