do you recomend MS-Access and MySQL???

[kolorasta]

I like working with MS-Access, but I don't want to use access databases anymore... I tried to use MySQL via ODBC and it seems to work fine...

Have anyone of you ever worked with Access & MySQL? Is it stable and safe??

The fact is that i want to develop more professional works, programs that work fine in a network. Now, I want to know what is the best choise... MS-Access databases, or MS-Access with MySQL db driver??¿?

sorry for my poor english

 

[ineuw]

I am in the same "boat" as you are. I prefer to use Access for its ease of use in VBA, DAO, ADO, forms and reports design. But, because of the very slow Access data retrieval in a multiuser environment, I have decided to switch to MySQL for the data tables.

I have been studying the issue of connection to MySQL from Access and in all my research of the past 3 months, there was not one complaint about reliability or slowness. In fact, MySQL server is rated on par with Oracle for speed.

Please note that prior to version 5.00, MySQL does not support relational integrity and automatic cascading between tables (as MS Access). MySQL version 5 is still in beta release.

I am also curious to know, how you linked into MySQL. Is it through code or through a pre-defined DSN file?

Would love to hear from you.

 

[kolorasta]

i´ve downloaded MyODBC-3.51.11-2-win.msi and installed it.. then I linked into MySQL via a pre-defined DSN.

I´ve been working with Access for a long time... and i've also been working with PHP and MySQL for the past 2 years. I know Access and I know MySQL... but I have to learn about Access with MySQL.
When you code... are there some differences in the syntax when you want to deal with the db via VBA code??

 

[ineuw]

I have been using Access since 1997 and am quite proficient. It is only recently that I have began to explore MySQL and Access.

The differences are in the SQL syntax and ADO is required, which is simpler and faster than DAO and better geared for DSN or DSN less connection. Also, I find MySQL easier and more intuitive than MS Jet SQL.

I also have MyODBC 3.51, and my problem is writing a DSN file. (I would appreciate if you can post a sample).

Also, if you are not aware, the MySQL website has some additional software, released/updated this past month which makes it easier to getting used to MySQL and the SQL language constructs.

These are:

The MySQL migration toolkit to convert Access tables to MySQL.
The MySQL Control Center
The MySQL Query Browser, which has an SQL command reference.
The MySQL Administrator

 

[kolorasta]

I connect to MySQL databases through User DSN or System DSN, not File DSN. I get an error..

i´ve been searchig for the best way to connect to a MySQL database.. and I found a discussion here

http://www.experts-exchange.com/Databases/MS_Access/Q_21249907.html

that says the best way to connect to a MySQL server is through a DSN-less connection... via code.

you can read this too

http://forums.mysql.com/read.php?37,26653,26653#msg-26653

If I have more info i will post it here

 

[ineuw]

Many thanks for your help.

Now, I must commit myself and tinker a little with a DSN-less connection. I was interested in creating a file DSN, just so to expand my knowledge, familiarity, and weigh my options as I am about to convert some of my applications from DAO to ADO.

Thanks again,