But I've really got to ask why you are doing all of this in a script.<BR><BR>Please tell me it's for a one-time setup of an app and not something that's going to be done regularly to your database.
im tryin 2 make a dynamic content website which ppl can add/delete their menu n submenus...from whut i seen u guys talkin...is it bad to do it?i mean delete table n create it all the time...or im using a wrong approach?is there any better one?n also the table name got space btween there...know not good...but need to put it like dat..fer 'my pictures' n 'my favorites'...tqq guys...so much hhelp :)
Is that any design that requires the use of DDL (CREATE TABLE, CREATE DATABASE, ALTER TABLE, etc.) as a part of normal operations is almost certainly a poor design (with any database, not just, or particularly Access). You certainly do *not* need spaces in those table names...Favorites should work just as well as "My Favorites". <BR><BR>You likely want to make these delineations at the row level, and *not* at the table level. <BR><BR>A database in production should have rows added and deleted...Not tables.