MS Access vs Mysql

I am MSaccess programmer. I had split my database. The server runs back-end
(tables only) and four machines are running the front-end (forms, queries,
reports and macros). I managed to download Myqsl and MysqlODBC and managed to
install them on a server (Advanced server 2000). I converted all the tables
from MSaccess to MYSQL. Now the question is how do I link the tables in MYSQL
to the workstations that are connected to the server? I

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MS Access vs Mysql

------=_NextPart_000_000E_01C69471.86A28150
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi there,



I hope this is the question you're asking - if not, sorry!



To connect MS Access clients to a MySQL DB, the easiest thing to do is to
create a DSN (usually under Data Sources (ODBC) in Administrative Tools,
within Control Panel). A DSN contains lots of connection information - the
driver used to connect, the server's IP or network name, connection options,
etc.



To create the DSN, make sure you've got myODBC installed (that's the
ODBC-MySQL driver) - it's a free download from mySQL.com. Then go to Data
Sources, under Control Panel->Administrative Tools and create a new system
DSN. Enter the details - port is usually 3306 but can be left blank - if
your server has a static local IP then you can enter that, but otherwise a
machine name is good, and look on the MySQL connector site about the options
you should choose when connecting from MS Access.

See: http://dev.mysql.com/doc/refman/5.0/en/myodbc-configuration. html and
http://dev.mysql.com/doc/refman/5.0/en/myodbc-configuration- connection-param
eters.html

See also:
http://www.washington.edu/computing/web/publishing/mysql-acc ess-3.5.html



Then, within Access, go to file->Import->Link Tables. Under "files of type",
choose ODBC databases (should be near to last entry). This will then bring
up a familiar "select data source" box - choose your System DSN and then hit
OK. Link the tables you want.



A note to consider: if you did an export from Access to create the MySQL
tables, check that you've set all the primary keys, otherwise Access will
prompt you for each table as to which field is primary or unique.



Hope that helps,



Al McNicoll

Integritec Ltd

http://www.integritec.co.uk





-----Original Message-----
From: Langson B.-Computer Specialist [mailto:langsonb@yahoo.com]
Sent: 20 June 2006 13:10
To: myodbc@lists.mysql.com
Subject: MS Access vs Mysql



I am MSaccess programmer. I had split my database. The server runs back-end

(tables only) and four machines are running the front-end (forms, queries,

reports and macros). I managed to download Myqsl and MysqlODBC and managed
to

install them on a server (Advanced server 2000). I converted all the tables

from MSaccess to MYSQL. Now the question is how do I link the tables in
MYSQL

to the workstations that are connected to the server? I



__________________________________________________

Do You Yahoo!?

Tired of spam? Yahoo! Mail has the best spam protection around

http://mail.yahoo.com




------=_NextPart_000_000E_01C69471.86A28150--

RE: MS Access vs Mysql

You install MyODBC on the clients, not the server, although you can have
it there too if you want, you just may not use it.

With MyODBC on each client you define a DSN in Control Panel (I assume
you are using Windows?). In Access you choose File/Get External
Data/Link Tables and choose ODBC data sources as the file type. You
should see your DSN there. When you select it, you should see the MySQL
tables and can link some or all of them. They then appear like tables in
Access. For efficiency you should use pass thru queries in Access where
possible to do any heavy processing that can be done on the server.

John B.

-----Original Message-----
From: Langson B.-Computer Specialist [mailto:langsonb@yahoo.com]=20
Sent: Tuesday, 20 June 2006 9:40 PM
To: myodbc@lists.mysql.com
Subject: MS Access vs Mysql

I am MSaccess programmer. I had split my database. The server runs
back-end
(tables only) and four machines are running the front-end (forms,
queries,
reports and macros). I managed to download Myqsl and MysqlODBC and
managed to
install them on a server (Advanced server 2000). I converted all the
tables
from MSaccess to MYSQL. Now the question is how do I link the tables in
MYSQL
to the workstations that are connected to the server? I=20

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg