howto create an access2000 database with only asp?

[noeska]

I am currently using access97 databases with my asp site. My providers suggest i switch to access2000 besause at bussy times acces97 supports 'crashes' access2000 does not. I don't have the budget to buy access2000 and i do not want to use illegal software. So i thougth maybe using ADO and ASP it should be possible to create an access2000 database.

I need some ideas on how to do such a thing. I don't like reinventing the wheel.

Thanks in advance!.

 

[CareBear]

From the description it would seem you can administer existing databases with it but not sure you can create them as well: http://www.codeproject.com/useritems/netdb.asp
An alternative is signing up for a free account with Brinkster. They have a crude database creation system. You could create an Access 2000 mdb file there and then just download it and use the first link to administer it.
It's some hassle but doable unless someone else finds a better way

If you do want to re-invent the wheel you'll need to use ADOX (=ADO eXtensions).
General ADO article with some mention of ADOX and some sample code: http://archive.devx.com/upload/free/features/vbpj/1999/06jun99/jm0699/jm0699.asp
ADOX FAQ page: http://www.able-consulting.com/ADOX_Faq.htm#Q2
ADOX reference at MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/admscadoapireference.asp