, 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
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
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
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
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
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
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
___/ 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
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
-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
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
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
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
13 matches
Mail list logo