473,805 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MySQL and linking to MS Acccess

36 New Member
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 1917
Denburt
1,356 Recognized Expert Top Contributor
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
IT Couple
36 New Member
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
IT Couple
36 New Member
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 Recognized Expert Top Contributor
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
2455
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 and can provide a solution. I have added HAVE_OPENSSL and HAVE_VIO to the preprocessor definitions and added the libeay32.lib and ssleay32.lib to the library modules settings. It compiles fine until it gets to mysqld. Then it throws the following...
74
8063
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 a MySql shop or a Postgresql shop. It's my opinion that we should be using PG, because of the full ACID support, and the license involved. A consultant my company hired before bringing me in is pushing hard for MySql, citing speed and community...
2
1900
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 Access to consider these date fields. Same thing happens when I import a (smaller) table into Access from MySQL - fields are converted to text. An additional, possibly related symptom (though doubtful) is that some records (10%) in a different...
1
2340
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 to create a table by linking to the MySql server it is showing the following error : -2147417851 Automation error. The server threw an exception. The command I am using is acc.DoCmd.TransferDatabase where acc is my Access application. Could...
1
1577
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 to create a table by linking to the MySql server it is showing the following error : -2147417851 Automation error. The server threw an exception. The command I am using is acc.DoCmd.TransferDatabase where acc is my Access application. Could...
1
3458
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 /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib10ObjectBaseE' has different size in shared object, consider re-linking...
14
4513
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 people. Is there a consensus on which one is the most stable, more or less supported and has good support for the standard MySQL features (e.g. stored procs)? Regards.
3
1639
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 don't want to rely on 3rd party apps for Migration, so.... I'm more than happy to write the connection code and transfer the data myself, but I don't know how to ensure that all Auto Number fields in the Access database transfer correctly, as in...
7
2867
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. My question is whether it is possible to set something up so that when linking to the MySQL database, the user name which is used for the MySQL connection is taken as the user's Windows ID. If so, then I can set up users and access grants in MySQL...
0
9716
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10604
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10361
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10103
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9179
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5676
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4316
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3839
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3006
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.