Help Me

Help Me

am 07.07.2005 15:57:14 von r.rizzo

I install MyODBC 3.51 driver Rel 3.51.11.00

I follow those instructions to connect an MYSQL table in MSaccess:

To import or link a table(s) from MySQL to Access, follow the instructi=
ons:
1. Open a database, or switch to the Database window for the open
database.
2. To import tables, on the File menu, point to Get External Data, a=
nd
then click Import. To link tables, on the File menu, point to Get=

External Data, and then click Link Tables.
3. In the Import (or Link) dialog box, in the Files Of Type box, sel=
ect
ODBC Databases (). The Select Data Source dialog box lists the
defined data sources The Select Data Source dialog box is display=
ed;
it lists the defined data sources for any ODBC drivers installed =
on
your computer. Click either the File Data Source or Machine Data
Source tab, and then double-click the MyODBC or MyODBC 3.51 data
source that you want to export to. To define a new data source fo=
r
the MyODBC or MyODBC 3.51 driver, please Section=A025.1.9.2,
"Configuring a MyODBC DSN on Windows".
4. If the ODBC data source that you selected requires you to log on,=

enter your login ID and password (additional information might al=
so
be required), and then click OK.
5. Microsoft Access connects to the MySQL server through ODBC data
source and displays the list of tables that you can import or lin=
k.
I don't know why because Nothing happen and is inpossible display=
s
the list of tables that I wont import or link.
There are no errors only the box of list of tables not appear.

In my MSacces applications there are some old Mysql tables connec=
tion
that run well, but NOW is impossible to make some new connection=



(6. Click each table that you want to import or link, and then
click OK. If you're linking a table and it doesn't have an index =
that
uniquely identifies each record, then Microsoft Access displays a=

list of the fields in the linked table. Click a field or a
combination of fields that uniquely identifies each record, and t=
hen
click OK. )


My best regards


Ruggero Rizzo
e-mail: r.rizzo@fime-motors.com

=



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org