need asp code to modify design of multiple MS Access MDBs

[Scotter]

I have an ASP application with MS Access 2002 backend.
This application I have 20 copies of running on the same server.
Each application is a different web site.

When I come up with a change - usually adding a field to one of the tables
in that app - right now I have to manually go into design mode for the table
for each of the 20 applications.

I would like some kind of automated way of doing this, preferably with ASP -
remote.

Ideas? Something you saw out there already built to do something like this?

Thanks!

--
Scotter

[[MSFT]]

Hi Scotter,

To modify a Access database, we can use a COM Library ADOX. It is included
in ADO and be able to define and modify database's structure like Access
and SQL server. Here is a sample to use ADOX in an ASP application

[url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q272268[/url]

Hope this help,

Luke
Microsoft Online Support

Get Secure! [url]www.microsoft.com/security[/url]
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Scotter]

I see how this code works on user and group objects.
I'm wondering if you know of an example that works on tables and fields?
Thanks!

"[MSFT]" <lukezhan@online.microsoft.com> wrote in message
news:7dU4LuLXEHA.2616@cpmsftngxa10.phx.gbl...

> Hi Scotter,
>
> To modify a Access database, we can use a COM Library ADOX. It is included
> in ADO and be able to define and modify database's structure like Access
> and SQL server. Here is a sample to use ADOX in an ASP application
>
> [url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q272268[/url]
>
> Hope this help,
>
> Luke
> Microsoft Online Support
>
> Get Secure! [url]www.microsoft.com/security[/url]
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>

[[MSFT]]

Here is a sample on adding a column to an Access database with ADOX:

Dim adoConn
Dim adoxCat As Catalog

Set adoConn = Server.CreateObject("ADODB.Connection")


adoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\db1.mdb;User Id=Admin;"

Set adoxCat = Server.CreateObject("ADOX.Catalog")

Set adoxCat.ActiveConnection = adoConn


adoxCat.Tables("table1").Columns.Append "c2cv"

For more sample on ADOX, you can refer to following link:

[url]http://doc.ddart.net/mssql/sql2000/html/mdacxml/htm/wpmigratingschema.htm[/url]

Luke

[Bullschmidt]

ADOX API Reference
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/[/url]
htm/adoddlo1.asp

- - - - -

Working with ADOX by Ramesh Balaji and Scott Mitchell - 1/31/2001
[url]http://www.4guysfromrolla.com/webtech/013101-1.shtml[/url]

- - - - -

Ease Data Access With ADOX
Use the new ADO object library to build and inspect your database
structure
by Jeffrey P. McManus
[url]http://archive.devx.com/upload/free/features/vbpj/1999/06jun99/jm0699/jm[/url]
0699.asp

- - - - -

Add tables with ADOX
[url]http://nuts4asp.com/tutorials/adox[/url]

- - - - -

ADOX FAQ
[url]http://www.able-consulting.com/ADOX_Faq.htm[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
[url]http://www.Bullschmidt.com[/url]
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Yan-Hong Huang[MSFT]]

Hello Scotter,

I was reviewing the thread. Do you have any more concerns on it? If the problem is not resolved yet, please feel free to post in the group and we
will follow up.

Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C [url]www.microsoft.com/security[/url]
This posting is provided "AS IS" with no warranties, and confers no rights.