Hi,

I have created a Jet(Access 2000) database in a Web Server and now i want to create tables for it dynamically in ASP by checking existence of Tables. I need the code for checking the tables existence without error using ADO in ASP file. I have used Provider to connect to the database.

If there is any other way to do this, please inform me.

A.D.Ramkumar

__________________
Ramkumar A D

hmm...this is interesting !!!

i haven't try this code in ASP Script, but you can try like this :
Made reference : ADO 2.5 and DDL and Security 2.5 or higher version

the code like this :

Dim cn as ADODB.Connection
Dim ra as ADODB.Recordset
Dim Ct as Catalog
Dim Tbl as Table
==============================================
 Put a ListBox into your Form Name it as LST1
==============================================
       after you set the connection then
==============================================
sub GET_TABLE()

  Set CT.ActiveConnection = Cn
  For Each Tbl in Ct.Tables
      LST1.Additem Tbl.Name
  Next
  Set Ct = Nothing
end sub

If in ASP Script i think, you should make a different page to showing all the
result.

Nice Coding . . . From Extreme's, bye
Call me if you got one . . . bye

Hi there,

Check out these two articles:

http://Imar.Spaanjaars.Com/ViewConte...px?CONTENT=252
http://Imar.Spaanjaars.Com/ViewConte...px?CONTENT=143

The first explains how to retrieve info about a database; the other describes how you can create an entirely new database.

Cheers,

Imar