Andreas Moroder wrote: > Daniel Kasak schrieb: >> Andreas Moroder wrote: >> >>> Hello, >>> >>> when I open mysql table with access 97 using the latet mysql-odbc >>> driver ( 3.51.12 ) I see only deleted records. >>> >>> What is happening ? >>> >>> I found many posts about this problem, but I can not, as told in this >>> posts, add timestamp or other fields because this tables are used by a >>> application I don't want to break. >>> >>> Is a solution without the need to change the tables ? >> >> >> You won't break anything by adding a timestamp field. Trust us :) >> And no, there is no way around this problem other than adding a >> timestamp field. >> > Hello Daniel, > > thank you for the info. > How to do this ? I know oracle, but I am new to mysql.
>From the 'mysql' command-line client, do: use DATABASE_NAME; ... where DATABASE_NAME is the name of your database ... and then ... alter table TABLE_NAME add MyTimeStamp timestamp(14); ... and change TABLE_NAME to the name of your table. This will put a timestamp field called 'MyTimeStamp' at the end of your table. You should then relink your tables in Access, using the 'linked table manager', or simply delete the linked table ( in Access ) and relink it. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
