MySQL and linking to MS Acccess

Hi

I have an MySQL database v5 on the web with data from my MS Access database which I migrated.

I want give options to my customers to interact with the database so I want to move it entirely to MySQL but I still want to use my MS Access database on my laptop.

So I'm thinking about linking the database by using ODBC Drivers 5.1 but I'm worried about data conversion issues.

So my questions are:
1) Is linking MySQL tables a good solution. Is there a better one?
I want to keep MS Access as I have a few features I use and it would take me ages to replicate them and because I create demos of my products I want to have an opportunity to develop 2 systems simultenously.

2) What kind of issue I can come across (convesion etc)

Many thanks in advance
Emil

re: MySQL and linking to MS Acccess

Moving the data to MySQL then linking the tables sounds like a logical plan. I don't think you should have to many problems as long as you get the appropriate data types. I have some MySQL experience but it has been a while. Let us know how the move goes and if you have any problems.

Welcome to Bytes!

re: MySQL and linking to MS Acccess

Hi Thanks for that

I have tried with one new table which is only on MySQL and it seems it worked without any issues. Dates are correct, data types locally have been set up correctly.

The only thing I noticed is that auto_increment has been added as number (not autonumber which is rather logical) and allows me to put any number (appart from duplicated) and the next number is what I put here manually + 1 which seems to be fine, besides this won't be populated so after update MySQL will assing the correct next number.

I will have a go with other tables and test forms, reports and VBA code and see how it goes.

p.s. Seems to be easier than I expected :D

Regards
Emil

re: MySQL and linking to MS Acccess

My first issue!!

I get a time out after a short while, but I've just read (after searching google) that I just need to set up a small query and requery it using VBA, I don't think this can be easilly changed apart from MySQL time out settings.

Regards
Emil

re: MySQL and linking to MS Acccess

Sounds like you have things under control at the moment glad its going well.