Reply
Access Databse --> MySql or Parsed into PHP
Old 10-08-2004, 06:30 PM Access Databse --> MySql or Parsed into PHP
theblt's Avatar
Super Talker

Posts: 119
Ok, here's a real doozy. I work for a privately owned daycare center doing general tech support around the center. I'm also starting to develope their website. I have much experience in both PHP and MYSQL. But I've never done this before. Ok, here goes:

They have 2 databases updated every now and then. 1 for clients, 1 for employees. Then, they have the punch in/out databases that are created once a month (e.g. 0804.mdb , 0904.mdb) but they are updated daily with the times the parents/employees are clocked in and out. The software they use was custom made to fit their needs. So uploading databases wasn't originally an option. So my first problem is, how can I upload these automatically, say at 7:00pm (an hour after they close). Second, how can I take the Access database files, and be able to read them with PHP OR convert them into MYSQL automatically. I want to be able to show client/employee information and be able to show the times both clocked in and clocked out online instead of only on their computers. Anybody have any idea on how to go about doing this?
theblt is offline
Reply With Quote
View Public Profile Visit theblt's homepage!
 
When You Register, These Ads Go Away!
     
Old 10-08-2004, 06:36 PM
sfackler's Avatar
Novice Talker

Posts: 13
Location: La Jolla
Cron jobs might help with the schedualed (sp?) db uploads.
__________________
TOasted Gamers
Go there. Now.
sfackler is offline
Reply With Quote
View Public Profile Visit sfackler's homepage!
 
Old 10-08-2004, 06:42 PM
theblt's Avatar
Super Talker

Posts: 119
Yea, I figured something like that would, though I've never dealt with Cron jobs before. But I still have to somehow show the information that's inside an Access mdb database.
theblt is offline
Reply With Quote
View Public Profile Visit theblt's homepage!
 
Reply     « Reply to Access Databse --> MySql or Parsed into PHP
 

Thread Tools

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.11287 seconds with 13 queries