Help Me
[email protected] Thu, 7 Jul 2005 15:57:14 +0200
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <OFBACBE270.A0D33334-ONC1257037.004AE9AC-C1257037.004CA6CE@bafin.intra> |
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 instructions:
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, and
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, select
ODBC Databases (). The Select Data Source dialog box lists the
defined data sources The Select Data Source dialog box is displayed;
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 for
the MyODBC or MyODBC 3.51 driver, please Section 25.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 also
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 link.
I don't know why because Nothing happen and is inpossible displays
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 connection
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 then
click OK. )
My best regards
Ruggero Rizzo
e-mail: [email protected]
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]