MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old July 11th, 2005, 11:05 PM
Gino Gino is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2005
Location: Manila, Philippines
Posts: 2 Gino User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 43 m 21 sec
Reputation Power: 0
MySQL and MS Access under FreeBSD?

Hello everyone,

Currently, I am using MS Access under FreeBSD(Unix) via Samba sharing. (5 users connected, simultaneously). Now, my plan is to make an interactive web page that will access data from MS Access using PHP/MySQL combination(not directly from MSAccess). I tried "linking" the MSAccess tables to MySQL Tables using ODBC, but it was too slow. My question now is, Is there any other way to feed the data from MS Access to MySQL in real-time? or whenever PHP needs the data. (as long as it is not manually done.)

I hope its clear. Thanks in advance.

Gino

Reply With Quote
  #2  
Old July 12th, 2005, 08:14 AM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,890 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8
What the purpose of Access?

It would be considerably faster if you were to simply convert your access database to MySQL.

Reply With Quote
  #3  
Old July 13th, 2005, 04:47 AM
Gino Gino is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2005
Location: Manila, Philippines
Posts: 2 Gino User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 43 m 21 sec
Reputation Power: 0
I agree with you on that, BUT the one maintaining the MS Access program are having problems with some of the data type conversion to MySQL. He's using DBManager Professional as his conversion tool. So, we need to use MS Access tables, until we could accurately migrate ALL data to MySQL.

Any suggestions?

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > MySQL and MS Access under FreeBSD?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT