[AccessD] Arthur - MYSQL

There's not a lot involved in setting up an Access FE to work with MySQL.
However, most of the tools that can import the data cannot import the
indexes. One that does however is dbScripter, which costs around $39 US (I
forget exactly, I bought it a couple of years back). You'll need MyODBC,
which you can download from the MySQL site. And finally, there's an issue
with ANPKs and MyODBC, so it's good practice to add a TimeStamp column to
every table in Access before you move the data. (In the absence of this
column, a new row says #deleted# in every column. The data is actually
there, but can't be seen without a refresh. Put a TimeStamp column in and
the problem disappears.)

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Frederick
Sent: April 22, 2003 6:45 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Arthur - MYSQL


I'm suprised to hear of MySQL buffs on this forum.  I'm just looking at it
and PHP.  I have apache, MySQL, MySQL Control Center, and PHP running on a
W2k Prof platform.  Control Center looks like an imitation of SQL Server
Enterprise Manager.  Are there ODBC or OLEDB drivers for MySQL that would
enable an Access FE and a MySQL BE?  Are there web forums(or fora?) for
MySQL?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bert-Jan Brinkhuis
Sent: Tuesday, April 22, 2003 3:44 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Arthur - MYSQL


All i know is from the SQL prompt: show fields from yourtablename And using
PHP: $query  = "select * from yourtablename";
                        $result = mysql_query($query);
                        itterate trough the result and with
                        mysql_field_flags($result, number) you can see which
column is the primary key.

HTH

Bert-Jan

----- Original Message -----
From: <Mwp.Reid at queens-belfast.ac.uk>
To: <accessd at databaseadvisors.com>
Sent: Monday, April 21, 2003 9:47 PM
Subject: [AccessD] Arthur - MYSQL


> Arthur
>
> Change of plan
>
> I need the sql statement to find out which is the PK in MySQL 
> something
like
>
> SELECT * FROM databaseName.INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
>
> Martin
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com