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.



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
 

Reply via email to