Are you really sure that you want to create multiple databases? and not just many tables in one database? A minor point, but it might make some things simpler. It sounds like you have two goals. 1) you want to make dynamic web pages that query a mysql database. 2) you want to manage the data in your database remotely. 1) is easy and I think you're already pointed in the right direction with php. 2) need NOT be done all via access and a manual upload process. You can remotely create tables, insert data and update existing records using a GUI tool from http://www.mysql.com/downloads/gui-clients.html Regards, Gary "SuperID" Huntress ======================================================= FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org ----- Original Message ----- From: "SteveW" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 16, 2001 8:13 PM Subject: Can I create database local in Windows & upload to Linux server. > Want to create databases programmatically, then upload to my host. > > Am using MS Access for my business database. Want to create a subset of the > data in a mySQL database, and upload these to my website. Must be done on a > routine basis and wanted to write the code in MS Access. Have been told by > my ISP host that it does not work that way, that I must use a PHP interface > to mySQL online (which would be to cumbersome, the way I understand it) and > the data is stored somewhere out there in never-never land on the server. > > I need to do this programmatically, generating the database from my current > business data. Would appreciate any advice and to email be directly. > > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php