Hi Adrian, and all. Thanks for answering.
I already get the 500 error page displayed telling me "Table 'XXX' already exists", how do I trap/stop this and show a more friendly ASP/HTML page with a "Try again" link? any examples would be a great help. I am still learning Access 2000, so please be gentle with me... :) --- In [EMAIL PROTECTED], Adrian Forbes - ITD <[EMAIL PROTECTED]> wrote: > 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. > <snip> > 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 -- ------------------------ 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/
