can access connect to a mysql database and get the table information?
--
Thanks in advance
Kherse Sefid 5 1852
On Apr 10, 2:33 pm, kherse sefid <kherse_se...@yahoo.comwrote:
can access connect to a mysql database and get the table information?
--
Thanks in advance
Kherse Sefid
With the appropriate ODBC drivers.
Check the MySQL site, they should have them for download.
On 10.04.2007 20:36, storrboy wrote:
On Apr 10, 2:33 pm, kherse sefid <kherse_se...@yahoo.comwrote:
>can access connect to a mysql database and get the table information? --
Thanks in advance Kherse Sefid
With the appropriate ODBC drivers.
Check the MySQL site, they should have them for download.
thanks for your quick response, I have found and installed this driver
from http://dev.mysql.com/get/Downloads/M....msi/from/pick
but could you pls give a more detailed information about how I actually
get my database from a mysql server into ms-access?
--
Thanks in advance
Kherse Sefid
On Apr 10, 4:01 pm, kherse sefid <kherse_se...@yahoo.comwrote:
On 10.04.2007 20:36, storrboy wrote:
On Apr 10, 2:33 pm, kherse sefid <kherse_se...@yahoo.comwrote:
can access connect to a mysql database and get the table information?
--
Thanks in advance
Kherse Sefid
With the appropriate ODBC drivers.
Check the MySQL site, they should have them for download.
thanks for your quick response, I have found and installed this driver
fromhttp://dev.mysql.com/get/Downloads/MyODBC3/mysql-connector-odbc-3.51....
but could you pls give a more detailed information about how I actually
get my database from a mysql server into ms-access?
--
Thanks in advance
Kherse Sefid
Look here:
23.1.3.2. Configuring a Connector/ODBC DSN on Windows http://dev.mysql.com/doc/refman/5.0/...n-windows.html
23.1.4.4. Using Connector/ODBC with Microsoft Access http://dev.mysql.com/doc/refman/5.0/...th-access.html
On Apr 10, 4:01 pm, kherse sefid <kherse_se...@yahoo.comwrote:
On 10.04.2007 20:36, storrboy wrote:
On Apr 10, 2:33 pm, kherse sefid <kherse_se...@yahoo.comwrote:
can access connect to a mysql database and get the table information?
--
Thanks in advance
Kherse Sefid
With the appropriate ODBC drivers.
Check the MySQL site, they should have them for download.
thanks for your quick response, I have found and installed this driver
fromhttp://dev.mysql.com/get/Downloads/MyODBC3/mysql-connector-odbc-3.51....
but could you pls give a more detailed information about how I actually
get my database from a mysql server into ms-access?
--
Thanks in advance
Kherse Sefid
If you intend to migrate and not just link the tables, there is sql
syntax in MySql to export the tables and structure, but I'm not sure
what it is off the top of my head. Their site should also provide
details of how to do that as well. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John |
last post by:
Hello.
I am currently working through a book on Dreamweaver and using PHP. I
am having a little trouble with setting up the database though. I
have php 4.2.3 and MySQL 4.0.20a. I am running...
|
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no...
|
by: Ryan Schefke |
last post by:
------=_NextPart_000_0077_01C34C8B.2B90C960
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
..I just sent this out to the win32 distribution list but no one has...
|
by: Maciej Wiznerowicz |
last post by:
Dear Sirs,
I can not start MySQL server.
More specifically, MySQL was running fine all the time since
installation. It stopped working after I used FmPro Migrator to convert
some File Maker...
|
by: Morten Gulbrandsen |
last post by:
Hi programmers, Good morning ;-)
I think something is wrong,
Running windows I believe first I have to set some password,
Which creates some user,
Then I can grant the required privileges, for...
|
by: chicha |
last post by:
Hey people,
I have to convert MS Access 2000 database into mysql database, the whole
thing being part of this project I'm doing for one of my faculty
classes. My professor somehow presumed I...
|
by: Beda Christoph Hammerschmidt |
last post by:
MySQL, Access, ODBC, Replication
Hello,
i have a central mysql database that is accesed by multiple clients
running MS Access with ODBC.
This works fine if Access has a permanent connection...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: B1ackwater |
last post by:
We've fooled around with Access a bit, but only using the
single-user store-bought version. It seems to be a good
database - versatile and infinitely programmable - and
can apparently be used as a...
|
by: Vanessa |
last post by:
Hi there
I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |