Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
ODBC - ODBC with the MySQL Connector/ODBC driver
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
About Data types

About Data types

2006-03-19       - By shreeseva

 Back
Reply:     1     2     3     4  

Dear friends,
I am using MySQL 5.0.17 on Win XP Prof. I have created a prototype database
design in Ms Access 2003 and using MySQL Migration tool uploaded this to MySQL
server. I have encounterred few problems with it.
1) Migration toolkit successfully transfered all tabels and indexes but all
Autonumber fields are transfered as 'int'. Also all boolean fields(In Access
'Yes/No' ) are transfered as 'tinyint'. Is there a bug the toolkit?
2) When I go for data entry through Access form It displays as '#deleted' in
all fields. Why?
I am entering data from Master form and when control goes into the Subform
linked with the master form it makes all entered fileds as '#deleted'. The
master form is related with documents table having one field as AutoIncrement
and subform is based on Transactions for that document. This Transactions table
also contains one Autoincrement filed. Both such fileds are PK's also.
Now when I changed the AutoIncrement to 'No' for Documents table it goes
correctly and not displayed '#deleted'. But when I entered data into
Transactions table having AutoIncrement still to 'Yes' then it displayed as '
#deleted'. Why?
Is this a bug or my mistake or ODBC driver problem or Access problem?

Please help
Thanks and regards.

CPK