I have been tasked to create an interface in Asp that allows a user to select a table or tables and insert new, modify, or delete records. The only problem is that this program should be univeral meaning that it shouldnt be tied with just one lookup table the user should select for instance "products" and be able to modify the "products" table or choose "Products Category" and be able to modify that table. Can someone point me in the right direction has to how to get started with this or have any source code for this kind of project. Has anyone used the ADOX.Catalog object? Should I start there? What are the draw backs from this solution as opposed to just creating an ASP page for each table I want to edit.

The main drawback would be that you'd have to create one page for every table. :) But also that if someone adds a table, you'll have to add a new page.

What database system are you using?

There are many existing products that will already do all this. For example (I can't believe I remember the name!): http://www.aspgrid.com/

Peter
------------------------------------------------------
Work smarter, not harder.

I am using SQL Server 2000. Would you happen to have any source code or sample app.

Perhaps you could request a value from a previous page that you can use to determine what table to lookup. (I wouldn't recommend passing the table name itself.)

MyTable = request("MyTable")
if MyTable = "Table1" then ThisTable = "Products"
if MyTable = "Table2" then ThisTable = "ProductCategories"

set rs = server.createobject("adodb.recordset")
sql = select * from " & ThisTable
rs.open sql, cn, 3, 3

One more thing:
If the whole thing is from ASP, I would think that you would need either different forms that apply to each table or a dynamic form that loads up options based on what table is selected.

Also, you might wind up with as many as four pages for the whole procedure; 1) First page to select the desired table. 2) Second page to list the records in the selected table and be able to select a record to edit or delete, as well as a link to add a new record. 3) Third page to load a form that is populated with the detail for the selected record, whereby you can modify it. 4) Fourth page to process whatever the action was that you desired. If it was edit or add then it would modify or append a record. If it was delete then it would delete the record.