Search results

If you lived anywhere near me I'd buy you a beer!

I truly appreciate your help and support and patience, it has been great! I only wish I could just download your knowledge into my brain, lol. I tried this very thing yesterday (logged on to my dynex router using http://192.168.2.1, and went to the section for port forwarding) I added a new...

I have been using a desktop and a laptop. The Desktop is running the MySQL Community Server and I have the ODBC Connector installed on both the laptop and desktop. When working within the LAN on the laptop I have no problem accessing the MySQL database files located on the desktop PC using the...

Looks like I hit the wall. I have tried everything I have read and know to connect to my pc via WAN. I constantly get the unable to connect to 68.34.xx.x . I can connect using the private IP when I'm on the network, but when I get I use another internet connection it just wont connect. I guess...

Thanks, informative read (and thanks for putting it in a pdf format). Inside my two computer set-up, everything works great and as it should. I expanded the network to 3 computers and no problems, and I am happy with performance. Although I did try to connect to MySQL database via WAN using my...

I understand completely I just did it this way as an inhouse test between two computers. Before this becomes adopted I will research the information you provided and set up the permission appropriately. Maybe I should start another thread but I am playing around with the ODBC linked table (in...

Thanks for checking that info out for me, it will come in handy, the quick work around had to do with reconfiguring my version of MySQL communty server to allow root access from another machine (simple check box). Again thanks a lot for everyone who helped out:)

Ok, im getting close I realized the problem was the IP address I was using. The IPv4 I was using was for the Hamachi client I had already installed. Here is the error I am getting now Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]Host 'MyPC' is not allowed to connect to this MySQL server...

Banana, I must say your help on this has been greatly appreciated. I have also come to understand a MySQL a lot better and will continue my knowledge in using it. I am still having trouble connecting but it's probably user error. Here is the error (HY000): Can't connect to MySQL server on...

I've managed to read several MySQL white papers, and have converted one of my databases to MySQL. Now I have an access front end and a MySQL backend, I understand how to connect to MySQL (importing and linking the data to access) and under the Machine Data Source i set up a Data Source (ie...

Well, my partners and I travel a lot during the year and actually spend a lot of time away from our small office. The biggest problem is that our ISP does not have an option for us to purchase a static IP address, so using vpn will not work for us. Tha is why mysql looks like the best option...

I’ve searched the web and this site and have found out it’s possible to connect a MS Access front end to a mysql back end. I am interested in taking my current database which is already split and change it to an access FE/ mysql BE. Since I already have a split database, I downloaded a program...

I created a very simple code that checks the current date, and if the the current date is greater or less than the pre programmes date open a msg box. Private Sub Command1_Click() If Date < 1 / 20 / 2010 Then Dim ButtonClicked ButtonClicked = MsgBox("Sorry, your current license has...

I was thinking of ways to ensure back up of data, and I wondered if there is away to write data to more than one table at the same time. If not what is the best way to accomplsih something like this? Basically if the network crashed could data written to a local table be used as a potential...

Thanks for the idea. I think I will try to just switch to a Access FE/ MySQL BE for now. The trick is seeing if I can connect this over the internet

I currently create programs in Visual Basic and MS Access. Things are going well but demand is also growing fast. Managing many software packages is becoming more and more time consuming. I am interested in finding out what I need to create the following. 1. A Web based database 2. Clients would...

OK, thanks guys for your help. I will try this a little later to see if everyting goes smoothly

Yes this is what I intend to do, I really dont know why I did the "-365" as an example. My only question would be if I could replace Date(), with a user defined date from a form. The issue occurs when a user decides they want to do a monthly report for "April", but the run the report on May...

I am trying have a calculated field which gives me the year to date amount of orders. I currently have a query which is set up to return the amount of orders Between user defined dates Example Between [forms]![fmr1]![txtbegdate] AND [forms]![fmr1]![txtenddate] Now this has worked fine but...

Thanks, my only concern is that I package this and burn the DB to a CD. Once I deliver the database it's no longer on my network. So I'm really looking for something that will allow me to send an update.....I have some thoughts on this..... but maybe it's better for me to just not use the...