I have an ASP that massages data to send to the client's
browser by changing the ContentType and disposition of
the page so that Excel will auto-open on the client's
workstation to view the data as a CSV file.
This works fine, however, the client has been saving the
data, then opening an Access database & importing the data.
The client would like to request the data on the site and
have the data return in the form of an Access database,
ready to open on the client's workstation.
Either this cannot be done OR I'm missing something...
rsTest.Open "SELECT ...", conDB, adOpenForwardOnly, adLockReadOnly
Response.Clear
Response.AddHeader "Content-disposition", "attachment;filename=Test.MDB"
Response.ContentType = "application/vnd.ms-access"
Response.flush
Response.BinaryWrite rsTest.getString
rsTest.close
' This looks good on the screen, but it doesn't return the
' proper binary format of an Access database, thus the client
' Access program doesn't recognize the mdb structure & fails.
--KevinZ
--Kevin
browser by changing the ContentType and disposition of
the page so that Excel will auto-open on the client's
workstation to view the data as a CSV file.
This works fine, however, the client has been saving the
data, then opening an Access database & importing the data.
The client would like to request the data on the site and
have the data return in the form of an Access database,
ready to open on the client's workstation.
Either this cannot be done OR I'm missing something...
rsTest.Open "SELECT ...", conDB, adOpenForwardOnly, adLockReadOnly
Response.Clear
Response.AddHeader "Content-disposition", "attachment;filename=Test.MDB"
Response.ContentType = "application/vnd.ms-access"
Response.flush
Response.BinaryWrite rsTest.getString
rsTest.close
' This looks good on the screen, but it doesn't return the
' proper binary format of an Access database, thus the client
' Access program doesn't recognize the mdb structure & fails.
--KevinZ
--Kevin