Yep - I could do that... Or I could use this: http://www.cynergi.net/exportsql/ I haven't tried "exportsql" yet, it probably will fall over or be a nightmare to get going knowing my current run of luck! Let's all put our hands together and pray that it works (and for world peace or something). Alex |:| Reply-to: alex.gemmell@xxxxxxxxxx |:| |-----Original Message----- |From: Gryffyn, Trevor [mailto:TGryffyn@xxxxxxxxxxxxxxxxx] |Sent: 12 May 2004 17:22 |To: PHP List |Cc: Alex Gemmell |Subject: RE: Linux/PHP/Access Database - oh boy :( | |In that case, you could write a PHP script on your PC (Windows right?) |that reads the data from the MDB file then posts the data to the MySQL |database. Sounds easy enough. Hah (that phrase has bitten me on the |backside more times than I can remember.. Challenges are fun though heh) | |-Tg | |> -----Original Message----- |> From: Alex Gemmell [mailto:alex.gemmell@xxxxxxxxxx] |> Sent: Wednesday, May 12, 2004 12:19 PM |> To: Gryffyn, Trevor; 'PHP List' |> Subject: RE: Linux/PHP/Access Database - oh boy :( |> |> |> Apologies if my situation isn't clear. My brain is |> noodle-soup after all |> this! |> |> I am given an updated copy of the MS Access database |> periodically. That |> needs uploading to the website and a few pages use it to |> populate themselves |> with relevant data. |> |> Basically - username/password check to login. If successful |> then show them |> most of the fields in their record. Simple! |> |> Simple, yeah, nothing to it... ;) |> |> Now my server admin are playing ball I have hope. If I can |> convert the MS |> Access db to MySQL without too many problems then I should be home and |> dry... |> |> |> Alex |> |:| Reply-to: alex.gemmell@xxxxxxxxxx |:| |> |> |-----Original Message----- |> |From: Gryffyn, Trevor [mailto:TGryffyn@xxxxxxxxxxxxxxxxx] |> |Sent: 12 May 2004 17:13 |> |To: PHP List |> |Cc: Alex Gemmell |> |Subject: RE: Linux/PHP/Access Database - oh boy :( |> | |> |I think you'd have the same issue with Chilisoft ASP as you |> would with |> |PHP because the issue isn't with the scripting language but with the |> |OS's support for ODBC or DSNless connections to an Access |> database. I |> |did a little reading on Chilisoft ASP a while ago and (1) |> it's not free |> |from what I understand and (2) I heard it doesn't function |> exactly how |> |ASP is supposed to so you could have some stability issues. |> The MySQL |> |thing along with MDBTools or something sounds like it could |> be the best |> |way to go. |> | |> |Or if you keep your master data set in MySQL and just use |> Access to pull |> |a copy from it when necessary for distribution (you said you |> distributed |> |the data via MDB files right? Or do people change the MDBs and that |> |becomes the master?) |> | |> |At any rate, good luck! And keep us updated! |> | |> |-TG |> | |> | |> |> -----Original Message----- |> |> From: Alex Gemmell [mailto:alex.gemmell@xxxxxxxxxx] |> |> Sent: Wednesday, May 12, 2004 12:09 PM |> |> To: Gryffyn, Trevor; 'PHP List' |> |> Cc: 'Robert Twitty' |> |> Subject: RE: Linux/PHP/Access Database - oh boy :( |> |> |> |> |> |> Thanks again Trevor and Bob! |> |> |> |> The reason I was mentioning ASP is because "Chilli Soft! ASP" |> |> thingy (?) is |> |> installed on the live (Linux/Apache) server. IIS doesn't |> |> come in to play |> |> (other than on my localhost I was (stupidly) testing on!). |> |> |> |> I have just got off the phone having managed to get the |> |> server admin to |> |> concede to allowing MySQL to be installed. Hopefully he will |> |> actually do |> |> this! |> |> |> |> If so, this will solve ALL my problems! Hurrah for |> |> Linux/Apache/PHP/MySQL! |> |> Hurrah! |> |> |> |> |> |> Alex |> |> |:| Reply-to: alex.gemmell@xxxxxxxxxx |:| |> |> |> |> Or call me for free using Skype: |> |> | |-- |PHP Database Mailing List (http://www.php.net/) |To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
