First off what you're doing sounds like a bad idea, and if I were you I'd re-think how you want your app to work.
The easiest way of doing this would be to use error handling to trap any errors. Create the table as normal and if you get an error number corresponding to the table already existing then you inform the user. -----Original Message----- From: llll_sole_llll [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 11:18 To: [EMAIL PROTECTED] Subject: [ASP] Check if table exists (A2K) Hi all. Not sure if this should be posted here or in an SQL/Access group. I am fairly new to Access but I was wondering if there is a way to check if a table exists in an Access 2000 database? -- Scenario -- I have a form with one input field that the user enters thier name, this will become thier table. Now, I want to check if that table exists, if not create it, if it exists then display a notice to say is already exists. -- End Scenario -- I am using ASP for the form and a seperate page to check the entered name, with Access 2000. Thanks for reading this. --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
