473,320 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
May 15 '09 #1
4 1893
Denburt
1,356 Expert 1GB
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!
May 15 '09 #2
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
May 17 '09 #3
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
May 17 '09 #4
Denburt
1,356 Expert 1GB
Sounds like you have things under control at the moment glad its going well.
May 18 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: renniw one | last post by:
Hi, Can anyone point me to a resource which details the process of compiling mysql server with openssl support on windows using VC++ preferable? If not, maybe someone has run across this problem...
74
by: John Wells | last post by:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either...
2
by: pholck | last post by:
A newbie question here: I'm linking to a MySQL backend table with a million+ records, where two fields are of type datetime. However Access considers those fields to be text. Can't seem to get...
1
by: gopinathanr | last post by:
I am having a VB 6.0 program where I am using an MS Access database. This database has some tables that have been created by linking to MySql database using the MySQL ODBC 3.51 Driver. When I try...
1
by: gopinathanr | last post by:
I am having a VB 6.0 program where I am using an MS Access database. This database has some tables that have been created by linking to MySql database using the MySQL ODBC 3.51 Driver. When I try...
1
by: grabro | last post by:
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following message. linux:/home/grabro # mysql-administrator...
14
by: Frank Rizzo | last post by:
I've been given a project to work with which involves connecting to MySQL from .NET 2.0 app. I've googled looked and there is a metric ton of different MySQL ADO.NET providers from different...
3
by: tc | last post by:
I have an app that I'm re-writing for MySql and MsSql, the old version connected to an Access database. It is more than likely that existing customers will want to upgrade to the later version. I...
7
by: coolsti | last post by:
I have the task to set up an application at work,using MS Access as a front end to a MySQL database. This will be done using an appropriate ODBC driver, and linking the MySQL database to Access. ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.