I'm stumped. I'm not so sure what is the right answer to your question. I'll do some research in Google and get back to you if I find an anything. You should email the people at iPage as they probably could give you an answer..
OK...now this has gotten deep. A search has turned up this solution.
MySql to Access.
And I am digging into it. Check it out...
Well I didn't get far. Installing the application went fine but when I try and import or link tables I get an error saying my db server doesn't exist....when if course it does. If anyone get's this to work, please let me know. Meanwhile, I will keep looking...
Worked fine for me on my local PC, are you trying to connect to an online server..
Sounds like you have put the wrong server name, hostname or database name in the fields during the install and connect procedure...
I have the client installed on my local pc and am connecting to the MySql server that drives my iPage website via the Internet. All of the variables are correct it just doesn't like what I am trying to do. I will continue to research...
If your settings are right do you have a firewall running it might block the connection..
Mine worked okay but my server is on my local PC as well as the client. Works great and is really worth the effort to get it going...
I didn't think of that. I just tried it though with the firewall disabled and it doesn't work. I am beginning to belive that my host only allows connections to the database from within the iPage domain (i.e. phpMyAdmin). Some are like that. So I am going to look at automating the exports from MySql....it will be a pain to do it manually each time...
You could export the tables using phpMyadmin, download the files and import them onto a mysql database on your PC. Then setup Access to it there..
Only thing is you would have to regularly keep the database up to date with the one online...
Also found this link on installing and connecting to online database using Access or Excel.
OK.....that would be better than trying to keep up with certain reports online. I just dowloaded MySql 4.0 and will install it. Wish me luck. I have never used anything other than my host's MySql...
Well that's not going to work. I opened the 3.5 meg install doc that came with the MySql download and it has enough instructions to launch the space shuttle. I am a functional user of OSC but certainly not a programmer or server expert. The install was easy but I was hoping for some type of gui to configure it. It is really this complicated or am I missing something? Do I need a server running on my laptop?..
I found a great tutorial the other day which gives step by step detail on installing Mysql, PHP, Apache and configure in Windows..
Here For All to Find..
Thanks so much...the last link gave a very clear set of instructions. Installed Apache and found MySql gui......
Unbelievable...in 1.5 hours I have installed and have running on my local machine:.
All of this because I just wanted to run a mysql-to-access application..
I can now work on my websites offline as a testbed. I am sure everyone else already knew this. That tutorial is the coolest thing out there..
This post has been edited by.
: 22 February 2004, 23:42..
Is the a way to copy or get a report to put into excel so I can use excel to work with my orders?.
I am getting so many orders , it's hard to go 1 by 1 online to copy the info and place into excel..
I sure hope I explained this right,.
I am going crazy try to figure out a way to do this,.
First of all, congratulations!!! You have what we call a "Class A" headache....so many orders that they are hard to keep up with. That's a good one to have..
Second, it can be done but it's not as easy as just downloading a file. If you have any Access experience, you can create a database that can handle what you need. You would export the seven(7) "Orders" tables in the "CSV for Ms Excel data" format(easiest to so if you use phpMyAdmin 2.5.2-pl1 as your mysql client)..
Once you have exported the tables you can import them into Access. Once your tables exist in Access you would then join the tables by "orders_id". Once you have done that you can create all types of forms, reports and crosstabs that can give you all types of information..
Now that I have said all that, I realize that we could use the same thing as our business grows. I will knock the rust of mu Access skills and will give it a try. If I come up with anything worthwhile, I will let you know. It will be a welcome distraction for a couple of hours...