Access Database Program

[NoahK1ng]

Hey folks, here's a question; but first the backstory!
I was working on my website on a different computer than I normally use, and this computer doesn't have access installed.

The Question:
Does anyone know if there is an asp application that anyone has written that would work essentially like access and allow me to modify my database using only my server?

If Not:
I think that this could work if you included one extra table in your database that simply held the names of every other table in the database. The program would query that table and put up a list of existing tables. The user could add tables, remove tables, or edit tables. In terms of editing, there would be an option to edit data fields and an option to edit data entries.
I don't think this would be overly hard to write, but you know, why reinvent the wheel? Does this exist? Or do I have a new summer project?

[BsCis99]

BsCis99: I am just guessing here. But if you have the Access database, but not Access, can't you still setup an ODBC DSN that will allow you to access the database from ADO or ADO.NET or VB or C#?

[NoahK1ng]

That is correct, you can. You cannot, however (to the best of my knowledge) simply get the database to reveal itself for you. You still have to know which tables you want to call up, what the column names are, etc. I want something that would display all of those.

[gish]

sorry..I ment to reply to this one a while ago.....there are several "sample" apps at hotscripts that do this.

www.hotscripts.com

[DNAunion2000]

NoahK1ng That is correct, you can. You cannot, however (to the best of my knowledge) simply get the database to reveal itself for you. You still have to know which tables you want to call up, what the column names are, etc. I want something that would display all of those.

DNAunion2000: Again, just guessing a bit here, but if you have Visual Studio .NET I think that the Server Explorer will show you the database schema...it does for SQL Server.

Also, there is a FillSchema method in ADO .NET. Once you connect to your database, I assume you could use FillSchema to get the schema of your database.

[NoahK1ng]

Thanks for the help all! Especially gish, that link gave me just what I needed!

[gish]

glad it helped....that place has a huge amount of resources and samples.
:)