saving MDB as HTM!? +ASP

[rop65828]

My guestbook MDB file has 280kb but when i save it to htm the new file size is 16k.

Well i can still add or remove fields from the new HTM file since it still is a database it even has icons for adding and removing fieds.

Now... can i access this new file with ASP instead of the large old MDB file!?!?!?

(I can post my ASP code for accessing the large MDB file if u want)

ANY HELP!?!?!? Please...

[mad_A]

It will depend on the ODBC settings on your server. Otherwise, you can write your own. See MSDN for code.

A

[rop65828]

the server im using is www.brinkster.com ( has free ASP for thoose who dont know)...
so is it possible!?!?!? do i have to change the code!?!??

--------------------------------------------------------------

<%
db1 = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("guest.mdb") &";DefaultDir="& Server.MapPath(".") &";DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=15"
Dim DBConn, strSECTION
Set DBConn = Server.CreateObject("ADODB.Connection")
DBConn.Open db1
Set CmdA = Server.CreateObject("ADODB.Recordset")
CmdA.Open "guest", DBConn,1, 3

if request("action") = "new" then

...

[mad_A]

I'm not really familiar with HTM - is it htm as in html, or a dB format?

[rop65828]

I just open the MDB file with Microsoft Access and then save it as "Data Access Page".
The file stays *.HTM and when u open it (outside access just like a web page) its a database with all the fields and even has icons to add, remove, step to next record etc. etc.
So it should be able to write/read the file with ASP since we can add, remove records.

PS - Tanks for the reply, and please keep replying... :)

[mad_A]

I'd say it is a linking html page to access your db. Have a look at it in a text editor.
Or stick it up in a zip file and I'll tell you.

A

ps. sorry for the delay getting back to you.

[rop65828]

yes... :( u were right... it's just a HTM page linking to a access database... to bad.. tanks anyway!

[mad_A]

No worries!
It would be nice to shrink a dB like that.
If you want a smaller dB file size try mySQL. It's very good and free.
Anyway - the dB is on your server, so it is only the htm/asp/php/flash that the user needs to download, adn with good sql you can really reduce the query time for data.

best of luck with it.