Access Database Utility

[Michael42]

Can anyone direct me to an ASP database utility to maintain Access 2k tables\fields for my ASP IIS 5 applications?

I am looking for an ASP application that I just pass my connection (DSLess of course) and it will list all my tables and corresponding fields allowing me to modify the values as required.

At this time I must download the Access file from my web host to local system, make the changes, and upload.

Thanks!!!

 

[Dynapen]

All you really need is a page that will allow you to type in SQL code to execute, and then set it to display the results. All the things that happen is access can be done with SQL commands.

Lists of the tables and objects can be obtained from the system tables (they are hidden by default in access). Unhide those, and build a simple table that allows you to type in a textarea, any SQL command you want, and then executes that command against the DB.

I can give you a example later if you want.

 

[Michael42]

Sounds cool. I would like to see your example.

Thanks very much,

Michael

 

[Dynapen]

<%
Conn = server.createobject(&quot;adodb.connection&quot

myConnString = &quot;Provider=MSDAORA;Password=yourpasswordhere;User ID=yourusername;Data Source=yourtnsnamesentry;Persist Security Info=TRUE&quot;

if Request.form(&quot;SQL&quot <> &quot;&quot; then
strSQL = reqeust.form(&quot;SQL&quot
conn.execute(strSQL)
end if

<form method=post>
<textarea name=SQL>
Insert SQL Statement to execute here
</textarea>
<input type=Submit value=Execute>
</form>

This would create a basic HTML form that would allow you to type in a SQL statement and the pass it to the page to execute it. If you add in values below to show whatever recordset what exist from the statement, then you can use it to see the objects in the tables.

A example SQL Statement would be (This is based on a SQL Server database, the table names will be different for Access)

Select * from sysobjects where object_type = 'Table'

This way you are querying the system table that the database uses to track it's objects to find out what objects exist. Again, the syntax might be a little off, but the basics of it will work.

 

[Michael42]

Many thanks - this can be very useful.

BTW, I just found this cool tool, I have done some testing with it and it looks very promising.

http://www.saintopatrick.com/asp/dbadmin.asp

I think is may truly be better than sliced bread itself.