473,804 Members | 3,686 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using Access and MySQL over Internet

2 New Member
Hi everyone,

I'm keen to use Access as a client application to access data from a MySQL database. The reasons are Access for its strength in reports creation and MySQL for its stability and scalability. I also intend to site the MySQL database with a web hosting service provider. This means I'll be trying to access the database over the Internet using MS Access.

I have managed to access MySQL using MS Access through MyODBC driver and get everything running well. But they are all siting in the same machine. To place the database over at the web hosting service provider end and access it will be my next step.

This is where i need help. When I setup my database at MySQL i need to grant access rights to users by using the SQL command "GRANT". The command would require the IP address of the accessing party which in this case is the machine that house my MS Access client. The problem is that my machine is accessing internet via an Internet Service Provider that assigns dynamic IP address to users. Being dynamic I will have problem typing an IP address for the accessing client when setting up at MySQL database. What can be done?

More info about setting up the Access/MySQL combo can be found at
http://www.nusphere.com/products/li..._mysql_odbc.htm

Hope I'm not confusing anyone. But if i do, pls drop me a line. I'll clarify.

And any thanks to anyone keen to help.

Cheers!
roy
Feb 24 '06 #1
2 3685
ashishm
13 New Member
Please take a Global IP. or
Deploy Database on a Host Service Provider.
Feb 25 '06 #2
gwalters
8 New Member
You can do either of these

mysql > grant all priviledges on mydata.* to username@IP identified by "password";
mysql > grant all priviledges on mydata.* to username identified by "password";

My question is what would be the specs for the internet connection as far as
speed to get the desired performance. I've done the normal broad band connection between SC and Calif and it was terrible. Any body know more about this??
Nov 13 '06 #3

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

Similar topics

4
1719
by: Otto Krüse | last post by:
Hello, I've made a small GUI program that connects with a MySQL database to collect information which is put on the screen. The database and the program are used for testing purposes so I installed them locally and only use them locally (so on my own computer). When I run the script from a system (WinXP) shell through the python interpreter all goes well. However when I make an executable program of it through py2exe there's a...
3
2219
by: Chuck | last post by:
Here is my setup. Netgear Router with a webserver and database server NAT'd behind the firewall. Microsoft Windows 2000, IIS 5 - Web Server Microsoft Windows 2000, MySQL - Database Server What I would like to have is a web application served up off my WS (web server) and that application access my DS (db server) without
14
2865
by: MLH | last post by:
I have a friend with a database application on a web server. He has invited me to attach to it so I can extract data from it periodically. I have a few questions... 1) I have a DSL connection to my ISP and I think my buddy has one too. Can I establish an ODBC connection to his data- base? What information would I need to gather that would allow us to do this? 2) Can I "turn the connection on & off" at will? Are there any
2
1552
by: areejan2000 | last post by:
Experts/Programmers please advice on these questions. 1. Is Mysql secure than MsAccess (there are softwares avilable to retrieve Ms Office Password) 2. Which 3rd Party tool Would You recommend for Administration,Query creation.... Etc 3.Any tools for setup Mysql database to ship with ApplicationProgram (Access need not be installed in a Windows machine)
0
2217
by: roychong | last post by:
Hi everyone, I'm keen to use Access as a client application to access data from a MySQL database. The reasons are Access for its strength in reports creation and MySQL for its stability and scalability. I also intend to site the MySQL database with a web hosting service provider. This means I'll be trying to access the database over the Internet using MS Access. I have managed to access MySQL using MS Access through MyODBC driver and get...
15
4649
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.
49
3242
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code, etc? Please explain -- Message posted via http://www.accessmonster.com
2
4070
by: David Dawson | last post by:
I have no experience using MS Access to interface with MySQL. I have a tiny MySQL database that might need to have Access connect with it over the internet and grab data/update etc. Is this practical and what does it take to do it? My project is not time sensitive but I'd like to see what methods I can use to do remote queries with my database running on a *nix/Linux server. Thanks
3
9692
by: Kevin Killion | last post by:
I've recently features to a system by making use of some simple MySQL access routines. It works fine at most test locations, correctkly accessing a MySQL database on an internet server. However, at certain test sites, I cannot access the database. We're online, and I can access web files, for example. But when trying to say hello to that MySQL database, the program fails at the "mysql_real_connect" call. The message is "Can't connect...
0
9706
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
9582
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10580
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...
0
10335
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9157
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...
1
7621
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6854
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4301
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

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.