2. PHPRunner General questions
  3. Microsoft Access
This topic is locked

Microsoft Access

 		6/12/2010 10:02:44 AM
PHPRunner General questions
H
 horsey_kim author

I am starting a new project. It is a special directory that will be physically published in book form. I use Linux server for my website, so I also wanted to build with PHPrunner a quick site to allow people to search for info online. They have to purchase the book in order to get the online access information.
I want to build this database using microsoft access, so I can use the data easily in my book for publishing. I see in PHPrunner I can use it to build a site for the internet.
Here is my question:
Does PHPrunner build some kind of flat file of the access database and publish it with the other phprunner files for my website? I obviously would rather not have 2 databases (mysql and access) to keep up the book and online searchable version.
I want to be able to update the book as needed in access and then I can publish new versions and at the same time just sync the database and reload the updated files of phprunner. I don't want the website connecting to my hard drive where the access database is stored.
Is this possible? Thank you for any information.
Kim
lewisgr 6/14/2010



I am starting a new project. It is a special directory that will be physically published in book form. I use Linux server for my website, so I also wanted to build with PHPrunner a quick site to allow people to search for info online. They have to purchase the book in order to get the online access information.
I want to build this database using microsoft access, so I can use the data easily in my book for publishing. I see in PHPrunner I can use it to build a site for the internet.
Here is my question:
Does PHPrunner build some kind of flat file of the access database and publish it with the other phprunner files for my website? I obviously would rather not have 2 databases (mysql and access) to keep up the book and online searchable version.
I want to be able to update the book as needed in access and then I can publish new versions and at the same time just sync the database and reload the updated files of phprunner. I don't want the website connecting to my hard drive where the access database is stored.
Is this possible? Thank you for any information.
Kim


Kim,
You can use Access to get to the MySQL Tables. You can also use Access you update the record in your MySQL database. You would need to setup an ODBC connection and that would be your link between the two systems.
H
 		horsey_kim author 6/16/2010



Kim,
You can use Access to get to the MySQL Tables. You can also use Access you update the record in your MySQL database. You would need to setup an ODBC connection and that would be your link between the two systems.


Thanks, I have not used Access very much, so let me see if I get this right. By using ODBC connection from access to mysql, When I updated Access it will auto update the mysql table. So then I can use access with my publishing software for creating the book and since access auto updated mysql, I can use phprunner/mysql to build the site. Allowing me only have to enter data onces for both printed publication and website. Is that correct?
Kim
T
 		tabonjing 6/16/2010

Guys,
This works for me.

In a Windows environment, there is no problem using mysql and access thru ODBC connection. In a linux server, you need another pc with windows OS to connect to the mysql database thru odbc.
H
 		horsey_kim author 6/16/2010

Thank you all for the information. If anyone else has Ideas I like to hear them.
Kim
lewisgr 6/17/2010



Thanks, I have not used Access very much, so let me see if I get this right. By using ODBC connection from access to mysql, When I updated Access it will auto update the mysql table. So then I can use access with my publishing software for creating the book and since access auto updated mysql, I can use phprunner/mysql to build the site. Allowing me only have to enter data onces for both printed publication and website. Is that correct?
Kim


Yes, thats correct. I don't know what the guy below mean by another computer. In my setup I built the entire DB in access. Then when I found out I needed the thing to be online I found Rackspace Cloud server. I used an ODBC connection to upload all my tables. I then bought NaviCat for MySQL to administrate the database. I had to change my check boxes fields to tinyint(2) and autonumber my Primarykeys. I also bought these book MySQL Crash Course by Ben Forta and MySQL Developer's Library by Paul DuBois. These books have been my bible on MySQL. Also you can download the MySQL Connector from: http://dev.mysql.com/downloads/connector/odbc/5.1.html
Glen
T
 		tabonjing 6/18/2010

Hi,
My laptop with Windows 7 OS contains my MS Access database. I used ODBC connection to create a link from Access to a MYSQL database which is hosted by a Linux server somewhere.