Hello, Yes there is a simple solution I already used:
Do not use CurrentDb() Instead, create a new Database Object, using your Mysql DSN and use this Object. Any transaction, including CREATE TABLE, will then be performed on the server. It is the same thing that Access do in the background, when you select an Access table, right click on it, select Export, and choose ODBC database. Maybe my explanations are not clear, if this the case, let me know, I will email you a sample code. Regards, Patrick "shit, another monday morning, but happy if this can help you" Latour [EMAIL PROTECTED] ----- Original Message ----- From: "Alexander Shaw" <[EMAIL PROTECTED]> To: "MySQL Win 32 List" <[EMAIL PROTECTED]> Sent: Monday, February 18, 2002 6:56 AM Subject: Create Tables in MySQL Database from Access > Hi all, > > Seem to be hitting another annoying problem and can't find an answer - which > no doubt will be simple. > > I'm attempting to create a temporary table to allow a delete query to work > using Currentdb.Execute "CREATE TABLE ..... etc." but this causes it to be > created within Access rather than on the server. > > What do I need to add/change to get it working on the server instead? > > TIA > > Alex > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 > > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > > --------------------------------------------------------------------- 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
