RE: RE: Info Needed to Promote MySQL!!

2001-09-26 Thread Adam Douglas
, September 24, 2001 6:08 PM To: venu; turner; mysql Cc: adouglas Subject: RE: RE: Info Needed to Promote MySQL!! As a quick note, I tried the same with MS SQL Server through its latest ODBC driver by adding the new column, and I couldn't see any changes in the linked tables from

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-25 Thread Adam Douglas
What I did to handle global changes was have one access file on the fileserver that everyone had a shortcut to. That way the updates were global since they were all to the same file. How is the speed of running Queries, Forms and Reports from Access using linked tables to MySQL? I've found it

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
What type of schema do mean here ? Because as you know, MySQL doesn't explicitly supports any schema's except the catalogs( in MySQL term 'database'). If you can elaborate what exactly the problem you are facing, then we can provide a rapid solution. Also, as for as I know, when I change

Re: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread David Turner
I've had the same issues. I have really avoided the dev side of things for some time so I'm not sure whether there's a way around it. Mainly just devoting myself to administration. Funny though I'm starting to write jsp stuff to monitor the databases more effectively. I agree with you on the

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
Hi Douglas and David !! I have the following setup... - MySQL 3.22.32 on OpenBSD v2.9 - MyODBC on Windows '98 SE - MS Access 2000 Cool !!! Now I've found when I do changes to a table schema the changes are not entirely at least reflected in a the same table linked in Access. I had

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
Now I've found when I do changes to a table schema the changes are not entirely at least reflected in a the same table linked in Access. I had once case where I changed a data type on one of the columns and that data type was not changed on the linked table in Access. I had to

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
Subject: Re: RE: Info Needed to Promote MySQL!! I was never able to see the changes in table structure with Access and Oracle unless I manually added the column to linked table in Access after I had added it in Oracle. Dave On Mon, Sep 24, 2001 at 02:34:30PM -0700, Venu wrote: Hi Douglas

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Venu
___/ www.mysql.com -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:43 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail) Subject: RE: RE: Info Needed to Promote MySQL!! Now I've found when I do changes

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
As a quick note, I tried the same with MS SQL Server through its latest ODBC driver by adding the new column, and I couldn't see any changes in the linked tables from Access 2002. So it shows clearly that, its some thing related to MS Access, not with the driver. It might be a bug from

Re: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread David Turner
-mail) Subject: RE: RE: Info Needed to Promote MySQL!! Now I've found when I do changes to a table schema the changes are not entirely at least reflected in a the same table linked in Access. I had once case where I changed a data type on one of the columns and that data

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Adam Douglas
Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Adam Douglas
Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools

Re: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread David Turner
What I did to handle global changes was have one access file on the fileserver that everyone had a shortcut to. That way the updates were global since they were all to the same file. Dave On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote: Another small research in Access made me to