Thanks Jochem, you have always provided me with extraordinary advice regarding database and ODBC issues. But I need to stop playing around and make this switch, I think I have outgrown MS Access, or I like that I have. One of my MS Access database is 21 megs. It has more than 60 tables and in one table theres 15,000 records. This is before going live. I am not comfortable with MS Access under this condition.
---------- Original Message ---------------------------------- From: Jochem van Dieten <[EMAIL PROTECTED]> Reply-To: [email protected] Date: Fri, 22 Dec 2006 11:14:21 -0400 > >Dwayne Cole wrote: >> >> I co-locate and every time I need to work with a datasource I download >> the MSAccess file to my local machine, make the changes then quickly >> upload the updated version. It's akward. Particularly considering >> that I manage as many as 25 live data sources (all with the same table >> structure). From my understanding, this wont work with mySQL because >> mySQL databases are not files. I wondering what's the process then. > >If you need to change the database, you send it the appropriate SQL command. >Either by typing the command yourself, or by using a GUI that translates your >clicks to the appropriate command and sends it. > >Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
