MS ACCESS Connection to MYSQL ODBC

------=_NextPart_000_00E4_01C5509C.E73B2360
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-NAIMIME-Disclaimer: 1
X-NAIMIME-Modified: 1

Hello;
I tried connecting to MYSQL ODBC driver, but when I open the table, I can't add to it. It is readonly unubdatable format.
Any suggestions

I am using Access 2000.

Thanks
Riyad

The enclosed information is STRICTLY CONFIDENTIAL and is intended for the use of the addressee only. University Hospitals Health System and its affiliates disclaim any responsibility for unauthorized disclosure of this information to anyone other than the addressee.

Federal and Ohio law protect patient medical information disclosed in this email, including psychiatric disorders, (HIV) test results, AIDs-related conditions, alcohol, and/or drug dependence or abuse. Federal regulation (42 CFR Part 2) and Ohio Revised Code section 5122.31 and 3701.243 prohibit disclosure of this information without the specific written consent of the person to whom it pertains, or as otherwise permitted by law.

------=_NextPart_000_00E4_01C5509C.E73B2360--

Re: MS ACCESS Connection to MYSQL ODBC

Riyad Naser wrote:

>Hello;
>I tried connecting to MYSQL ODBC driver, but when I open the table, I can't add to it. It is readonly unubdatable format.
>Any suggestions
>
>I am using Access 2000.
>
>Thanks
>Riyad
>
>The enclosed information is STRICTLY CONFIDENTIAL and is intended for the use of the addressee only. University Hospitals Health System and its affiliates disclaim any responsibility for unauthorized disclosure of this information to anyone other than the addressee.
>
>Federal and Ohio law protect patient medical information disclosed in this email, including psychiatric disorders, (HIV) test results, AIDs-related conditions, alcohol, and/or drug dependence or abuse. Federal regulation (42 CFR Part 2) and Ohio Revised Code section 5122.31 and 3701.243 prohibit disclosure of this information without the specific written consent of the person to whom it pertains, or as otherwise permitted by law.
>
>
>
http://dev.mysql.com/doc/mysql/en/msaccess.html

Most importantly, you need a primary key and a timestamp in every table.

--
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: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org