Access+mysql?

[hair]

Hi there

Did someone connected a Access database to a windows Mysql db through ODBC?

I am talking about the windows version of mysql and windows version of ODBC drivers for windows

Thank you

 

[Dugantrain]

I believe that you will need to download the MySQL ODBC drivers, but, yes, it is possible to configure an Access db to connect to MySQL.

 

[hair]

I did that
I installed them too
started mysql as service

The thing is when u want to upsize the tables access knows only Ms sql server. So I have to connect to mysql by a string connection I suppose. It's only that I don't have any idea of how to even start this. Plus, my actual work is made with DAO and I am not sure if I can keep it like this...

 

[Dugantrain]

Setting up links is pretty easy; just use the Link Table Wizard, Select ODBC Drivers, and then select the MySQL Database which you have set up drivers for. Someone else can probably give you more advice on upsizing; I do this configuration quite a bit with DB2 databases, but what I have to do is pull down large chunks of data and work with it locally, so my set-up is really not "upsized" (i.e. I'm not passing data back and forth, as you're probably going to be trying to do).

 

[hair]

before even trying to do that

if I have only two users who use this access database

if this database gets around 1500 new lines a month
if those two users work on the same table (tables)

what is the chance that I get in trouble when let's say they modify the same recordset in the same time (or when is a loop through a recordset opened on the other side, it will be the case)?

Is there a chance for my db to loose records or they will have a message error? Or should I apply a different strategy when I open a recordset in DAO to avoid troubles?

any advice or sending to a link is welcome and appreciated

 

[Pat Hartman]

The database engine is responsible for managing concurrency. Jet handles this fine by using the .ldb file to track who is doing what. I don't know how MySQL handles the problem but if it is a "real" RDBMS, it should.

The upsizing wizard only works for SQL server databases. To "upsize" to anything else, you would need to first create the database and tables within it. Then you would link to those tables and finally, create queries that select the data from your Jet tables and append the data to the MySQL tables.

 

[hair]

That's what I was thinking, Pat

So if I share a normal Access database(not a project) in network and there are two persons working on it in the same time, it should be ok