List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:June 15 2000 4:29pm
Subject:Re: Access 2000 -> MyODBC Sharing
View as plain text  
Thanks for the response.  What I did was re-designed the form from a wizard
and it started working again (weird).  One problem I still have is Access 2000
not displaying TIME type fields.  Can you confirm this?

Also, since I am sharing this database, I've tried to set up FILE DSNs for
MyODBC, but they don't seem to work... I fill out the whole form and check the
matching rows/manager cursors, and then it says it failed to create the DSN.

Any suggestions?

Thanks!

Graeme


----- Original Message -----
From: "miguel solórzano" <miguel@stripped>
To: "Graeme B. Davis" <GraemeD@stripped>; <mysql@stripped>
Sent: Tuesday, June 13, 2000 4:15 PM
Subject: Re: Access 2000 -> MyODBC Sharing


Hi

There are some problems with Access 2k, the only work around is:

Set the ODBC DSN file with:

Return matching rows (checked)
Use manager cursors (exp) (checked)

When making insert/edit process all the fields must be filled and each
table must have
a primary key, which it selected when you make the link issue.

Regards
Miguel



At 15:39 13/06/00 -0400, Graeme B. Davis wrote:
>Hello,
>
>I have a situation where I have an Access 2000 database which has linked
>ODBC tables to MySQL.  I'm having lots of problems with Access crashing on
>the client machines accessing this database.  I was wondering if anyone is
>using Access 2000/MyODBC in a multiuser environment and if so, how are
>things set up?
>
>Also, Access 2000 won't show the TIME fields properly and also will crash
>client's trying to update DECIMAL fields.
>
>Any insight?
>
>Thanks!
>
>Graeme
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/php/manual.php3" before
>posting. To request this thread, e-mail mysql-thread40288@stripped
>
>To unsubscribe, send a message to:
>     <mysql-unsubscribe-solorzano=intermol.com.br@stripped>

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Miguel A. Solórzano         |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:miguel@stripped     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     São Paulo - Brazil          |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+


--
---------------------------------------------------------------------
Please check "http://www.mysql.com/php/manual.php3" before
posting. To request this thread, e-mail mysql-thread40292@stripped

To unsubscribe, send a message to:
    <mysql-unsubscribe-GraemeD=uu.net@stripped>



Thread
Access 2000 -> MyODBC SharingGraeme B. Davis13 Jun
  • Re: Access 2000 -> MyODBC Sharingmiguel sol√≥rzano13 Jun
    • Re: Access 2000 -> MyODBC SharingGraeme B. Davis15 Jun
  • RE: Access 2000 -> MyODBC SharingBrian Tuley13 Jun