Hi,

We run MySQL 4.1.9, MyODBC 3.51.10 + MS Access as a front-end (forms and
reports)
The Access front-end is a single shared file on our network. Each client
connect to it through MyODBC (with personal settings - user/passwd).
The problem is that when we change the structure of tables, the "Linked
table Manager" works only for the client who makes the update. I mean :
other clients cannot connect to the tables anymore (message is : 'ODBC
connection failed')
Is there a way to configure MyODBC so each client can read the tables
whoever makes the update through the "linked tables manager" ?
If I set up a unique "system DSN" on each client, it works, but MySQL
user's privileges don't work anymore, so it's no suitable.
I can copy a version of the Access front-end on each client to solve the
problem, but I'll have to tell everyone to re-link the tables every time
changes are made to the structure, which is not that good either.
Does anyone have an idea ? I hope I was clear enough about my problem ...
Thanks in advane !

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

Hello,

I have a copy of MS Access front-end with automatic relink linked tables =
at start up, and it works fine. You may need to modify linked tables conn=
ection string if you don't want to install DSN on each client. The connec=
tion string I use for linking tables and connecting to MySQL:

DRIVER=3D{MySQL ODBC 3.51 Driver};DESC=3D;DB=3Ddatabase;SERVER=3Dxx.xx.xx=
..xx;UID=3Duser;PASSWORD=3Dpass;PORT=3D3306;SOCKET=3D;OPTION =3D2050;STMT=3D=
;

Regards,

Artem Koltsov


> -----Original Message-----
> From: Christophe [mailto:christophe_nauwelaers [at] scarlet.be]
> Sent: Monday, January 31, 2005 5:05 PM
> To: myodbc [at] lists.mysql.com
> Subject: MyODBC + Access Linked Tables : connection failed from other
> clients
>
>
> Hi,
>
> We run MySQL 4.1.9, MyODBC 3.51.10 + MS Access as a front-end
> (forms and
> reports)
> The Access front-end is a single shared file on our network.
> Each client
> connect to it through MyODBC (with personal settings - user/passwd).
> The problem is that when we change the structure of tables,
> the "Linked
> table Manager" works only for the client who makes the
> update. I mean :
> other clients cannot connect to the tables anymore (message
> is : 'ODBC
> connection failed')
> Is there a way to configure MyODBC so each client can read the tables
> whoever makes the update through the "linked tables manager" ?
> If I set up a unique "system DSN" on each client, it works, but MySQL
> user's privileges don't work anymore, so it's no suitable.
> I can copy a version of the Access front-end on each client
> to solve the
> problem, but I'll have to tell everyone to re-link the tables
> every time
> changes are made to the structure, which is not that good either.
> Does anyone have an idea ? I hope I was clear enough about my
> problem ...
> Thanks in advane !
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=3Dartem.koltsov [at] wfinet.c om
>
>
=A0
Attention:
Any views expressed in this message are those of the individual sender, e=
xcept where the message states otherwise and the sender is authorized to =
state them to be the views of any such entity. The information contained =
in this message and or attachments is intended only for the person or ent=
ity to which it is addressed and may contain confidential and/or privileg=
ed material. If you received this in error, please contact the sender an=
d delete the material from any system and destroy any copies.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

------------=_1107293349-3780-36
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Christophe wrote:

> Hi,
>
> We run MySQL 4.1.9, MyODBC 3.51.10 + MS Access as a front-end (forms
> and reports)
> The Access front-end is a single shared file on our network. Each
> client connect to it through MyODBC (with personal settings -
> user/passwd).
> The problem is that when we change the structure of tables, the
> "Linked table Manager" works only for the client who makes the update.
> I mean : other clients cannot connect to the tables anymore (message
> is : 'ODBC connection failed')
> Is there a way to configure MyODBC so each client can read the tables
> whoever makes the update through the "linked tables manager" ?
> If I set up a unique "system DSN" on each client, it works, but MySQL
> user's privileges don't work anymore, so it's no suitable.
> I can copy a version of the Access front-end on each client to solve
> the problem, but I'll have to tell everyone to re-link the tables
> every time changes are made to the structure, which is not that good
> either.
> Does anyone have an idea ? I hope I was clear enough about my problem ...
> Thanks in advane !
>
This is a known issue with that version of MyODBC ( 3.51.10 ). Look back
through the archives. You don't have to go back far ... 2 days?

--
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 [at] nusconsulting.com.au
website: http://www.nusconsulting.com.au


------------=_1107293349-3780-36
Content-Type: text/plain; charset=us-ascii

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
------------=_1107293349-3780-36--